Comments
Sort by recent activity
On this particular project, the database contains 33 tables, and 12 of them have "seed" data. These are merely static lookup tables.
Mike / comments
On this particular project, the database contains 33 tables, and 12 of them have "seed" data. These are merely static lookup tables.
Mike
Thanks for your prompt reply.
Our data scripts only contain Insert statements. There is 1 data script for each table that requires "seed" data.
Yes, it would be wonderful if SQL Data Compare could create a set of data scripts from an existing database, similar to what SQL Compare does.
Thanks again,
Mike / comments
Thanks for your prompt reply.
Our data scripts only contain Insert statements. There is 1 data script for each table that requires "seed" data.
Yes, it would be wonderful if SQL Data Compare could...
On average, these table have 50 rows or less. The maximum number of columns in any table is 12.
Mike / comments
On average, these table have 50 rows or less. The maximum number of columns in any table is 12.
Mike
I have 2 databases with identical schema. One contains only lookup data - this is what we would deploy to a new customer. The other database is the operational database - the one that we test our software against.
To prevent the operational database from growing too large, or when trying to isolate a bug in the data services, I sync its data with the the database that contains the lookup data. This results in non-lookup data being deleted.
Prior to last week's update, SQL Data Compare would reset the Identity columns to start at 1. Ever since the update, the Identity columns are not reset, and subsequent Inserts will not start at 1. Unfortunately this causes a number of our unit tests to fail.
In the project options, the "Reseed Identity Columns" option still exists, but it doesn't do anything. / comments
I have 2 databases with identical schema. One contains only lookup data - this is what we would deploy to a new customer. The other database is the operational database - the one that we test our...