Red Gate forums :: View topic - SQL Data Compare From Scripts Folder To Empty Database
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK 10
SQL Comparison SDK 10 forum

SQL Data Compare From Scripts Folder To Empty Database

Search in SQL Comparison SDK 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
robert.barnes.btl



Joined: 29 Nov 2013
Posts: 1

PostPosted: Fri Nov 29, 2013 5:29 pm    Post subject: SQL Data Compare From Scripts Folder To Empty Database Reply with quote

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?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6581

PostPosted: Mon Dec 02, 2013 3:06 pm    Post subject: Reply with quote

The SDK has three APIs - Redgate.SQLCompare.Engine synchronizes database schema, RedGate.SQLDataCompare.Engine synchronizes the data, and RedGate.SQLPackager.Engine packages the schema and data into an executable.

You must synchronize the schema before synchronizing the data. This example may help: http://sdk.red-gate.com/index.php/SQL_Compare_%26_Data_Compare_used_to_restore_schema_and_data
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group