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

  • Alex BAlex B Posts: 1,008 Diamond 4
    Accepted Answer
    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?
  • srive326srive326 Posts: 2 New member
    Accepted Answer
    Hello Alex,

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