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
Hello, 

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? 
Tagged:
· Share on Twitter

Best Answers

  • Alex BAlex B Posts: 1,157 Diamond 4
    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,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
  • srive326srive326 Posts: 2 New member
    Answer ✓
    Hello Alex,

    Thank you for your response! Much appreciated. 
    · Share on Twitter
Sign In or Register to comment.