Options
SQL Data Compare From Scripts Folder To Empty Database
robert.barnes.btl
Posts: 2
Hi,
I am looking at using the SQL Data Compare API to generate a script that would update add static data to a database.
It works using the provided example after modifying it to work the other direction:
StaticDataWithScriptsExample.cs
but only if the target has already got the tables.
Is it possible to generate the data upgrade script assuming that the tables already exist?
I am looking at using the SQL Data Compare API to generate a script that would update add static data to a database.
It works using the provided example after modifying it to work the other direction:
StaticDataWithScriptsExample.cs
but only if the target has already got the tables.
Is it possible to generate the data upgrade script assuming that the tables already exist?
Comments
You must synchronize the schema before synchronizing the data. This example may help: http://sdk.red-gate.com/index.php/SQL_C ... a_and_data