SQL Data Compare for table that only exists in one database.

Automate and integrate using the SQL comparison API

SQL Data Compare for table that only exists in one database.

Postby huynh07 » Mon Jul 14, 2014 8:42 pm

Hi. I'm able to use the Redgate API to automate SQL Data Compare but when a table exits in just one database, it's not able to generate the script to populate that table.

Is there a way to generate a script for a table that only exists in one database?
huynh07
 
Posts: 4
Joined: Thu Jun 19, 2014 5:57 am

Postby eddie davis » Wed Jul 16, 2014 10:36 am

Thank you for your forum post.

Ideally when performing a data comparison using SQL Data Compare or SQL Data Compare API, the schema or database objects of each data source will be identical.

The SQL Data Compare API will not generate and create the table for you in the target data source.

As you are using the Comparison SDK, you will need to use the SQL Compare API to compare the schema and deployment the objects that exist only in the source to the target.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 998
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby huynh07 » Wed Jul 16, 2014 6:47 pm

What I'm trying to do is to do both schema and data compare at the same time and generate one script do match both database. Is the API not capable of doing this when there's content in a new table that's just in the source database?
huynh07
 
Posts: 4
Joined: Thu Jun 19, 2014 5:57 am


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests