SQL Data Compare From Scripts Folder To Empty Database

Automate and integrate using the SQL comparison API

Moderators: Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

SQL Data Compare From Scripts Folder To Empty Database

Postby robert.barnes.btl » Fri Nov 29, 2013 5:29 pm

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?
robert.barnes.btl
 
Posts: 1
Joined: Fri Nov 29, 2013 5:23 pm

Postby Brian Donahue » Mon Dec 02, 2013 3:06 pm

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_C ... a_and_data
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Comparison SDK 10

Who is online

Users browsing this forum: No registered users and 0 guests