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

huynh07

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?

Eddie D

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

huynh07

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?