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

Can Redgate deploy differences found to a third database different than the source and target?

srive326srive326 Posts: 2 New member
edited July 11, 2019 6:43PM in SQL Data Compare

Is it possible to use Data Compare to compare two databases and then deploy the rows that are different to a database not used as source or target? 

Best Answers

  • Options
    Alex BAlex B Posts: 1,146 Diamond 4
    Hi @srive326,

    You can use the option to create a deployment script that you can run on any SQL instance you wish:

    Having said that, this deployment script is specific to the differences between the source and target database, so if the third database is not in the same state as the original target database, then the script may error.

    Kind regards,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
  • Options
    srive326srive326 Posts: 2 New member
    Hello Alex,

    Thank you for your response! Much appreciated. 
Sign In or Register to comment.