Can SQL Data Compare work with a disconnected network?
steveculshaw
Posts: 16 Bronze 2
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.
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?
Cheers,
SteveC.
SteveC.
Tagged:
Best Answer
-
Alex B
Posts: 1,158 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,
Alex
