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

Can SQL Data Compare work with a disconnected network?

Can SQL Data Compare work with a disconnected network?

I'm looking at requirement for daily (nightly) synchronisation between two databases.

The complication is there is no direct connection between them, and I can only transfer text files, specifically SQL, between the two networks.

My simplistic approach would be on the source network run a comparison between the current database versus the backup from the previous night to generate SQL with all the changes. Transfer the SQL to the other network. Apply the change SQL to the target database.

Could SQL Data Compare handle this?

Best Answer

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

    Indeed it can.  You can compare a live database to a backup (see this page on "Working with backups") and create a deployment script.  You can then transfer this script file to another machine and run it there, but that is outside of SQL Data Compare at this point.

    I hope that helps!

    Kind regards,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.