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

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?

Comments

  • Eddie DEddie D Posts: 1,805 Rose Gold 5
    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
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • 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?
Sign In or Register to comment.