Stack Overflow
Stack Overflow

Questions tagged [database-scripts]

22 questions
0
votes
1 answer

Do inherited keys need some kind of creation in SQL creation scripts?

I'm trying to represent inheritance (I know) in creating a database. I have it figured out, but I'm not sure if I need to represent the PK that my tables inherit when creating tables. I have a FoodClass relation with the PK FoodClassID from which…
Dub
  • 27
  • 6
0
votes
2 answers

Oracle query in an array loop - weird result

I am looping through an array and performing an insert/update. In the loop, I check if record exists. If not, perform insert. If it does, then perform update. STRING_SPLIT_FNC is a package that takes a string and splits it on delimiter (~) and…
saz
  • 291
  • 4
  • 16
0
votes
1 answer

Maintaining Database Scripts

We have a long running project and we have continuous database scripts included in the project. Currently we use a manual way to run those scripts which I think does not work in a long run and the repository which saves these files only gets…
Immortal
  • 1,233
  • 4
  • 20
  • 47
0
votes
1 answer

Entity Framwork migration script for multiple contexts fails over existing __MigrationHistory table

We have a project that contains multiple EntityFramework contexts, each with migrations enabled. Now when we create a full migration script using Update-Database -SourceMigration $initialDatabase -script we get a script per context. This script…
Robba
  • 7,684
  • 12
  • 48
  • 76
0
votes
1 answer

How to run a SQL Server 2008 R2 Database Script using sqlcmd in C#?

i am new to run SQL Scripts using sqlcmd in C#. i saw some code in Internet but i am not understanding how it Works. string path = string.Empty; OpenFileDialog opd = new OpenFileDialog(); opd.Filter = "sql files|*.sql"; …
Anjali
  • 1,680
  • 4
  • 26
  • 48
0
votes
1 answer

Executing queries from sqlite file in iOS

Is it possible to read a .sqlite script with row insertions and updates in iOS? Or if you want to read sql statements from a file, you can only read the file line by line as if it were a regular text file? I need to make a large amount of row…
AppsDev
  • 12,319
  • 23
  • 93
  • 186
0
votes
0 answers

Database script not executing

In my sqlserver 2008 R2 I have a database script which generate successfully, but when I am trying to execute that script its only shows Executing query message and nothing happen. I had waited at-lest 10 minutes for result but force fully I have…
Sagar Upadhyay
  • 819
  • 2
  • 11
  • 31
1
2