How can we help you today? How can we help you today?

Can SQL Compare work with a disconnected network?

Can SQL 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 schema comparison between the current database versus the backup from the previous night to generate SQL with all the changes in the schema. Transfer the SQL to the other network. Apply the schema change SQL to the target database.

Could SQL Compare handle this?
steveculshaw
0

Comments

4 comments

Sort by
  • Alex B
    Hi @steveculshaw,

    Hello again! 

    As stated in the SQL Data Compare forum, yes, you can work with backups (see this page for the SQL Compare version of that document).

    Kind regards,
    Alex
    Alex B
    0
  • David Atkinson
    That should work. An alternative to the backups (as comparing to backups can sometimes be slow) would be save a schema snapshot from the target database and use this as the target to generate the script. To save a snapshot you can either use SQL Compare, its command line or a free utility called SQL Snapper (which is in the installation folder of SQL Compare, but can be copied out).
    David Atkinson
    0
  • Alex B
    Hi  @steveculshaw,

    Also, just to let you know I've deleted the duplicate post of this!

    Kind regards,
    Alex
    Alex B
    0
  • steveculshaw
    Alex B said:
    Hi  @steveculshaw,

    Also, just to let you know I've deleted the duplicate post of this!

    Kind regards,
    Alex
    Thanks Alex
    steveculshaw
    0

Add comment

Please sign in to leave a comment.