What are the challenges you face when working across database platforms? Take the survey
Options

Using SQL Compare to dump data with Table differences

We are using SQL Compare to dump our Production data to our Sandbox environment. a few of the tables have changed between the Production environment and our Sandbox and the "Database" deployment is failing because of column differences. Is there an options setting, perhaps "Use DROP and CREATE instead of ALTER" that will copy the new Production Table contents over to our Sandbox? Now bear in mind there are constraints on our table and foreign key constraints to it as well.

Thanks in advance for your review and am hopeful for a reply.
Tagged:

Answers

  • Options
    You need to use SQL Compare to update the schema first and then use SQL Data Compare transfer the data. Can you confirm if the schema of the table in your sandbox has been updated?

    If so, can you share a screenshot of the error you are getting with SQL Data Compare when migrating the data? What's the version of SQL Compare and SQL Data Compare?

    Thanks.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.