Synchronizing to completely disconnected databae RRS feed

  • Question

  • I have a scenario and I haven't found a solution yet. I have two databases in two separate SQL Server 2008 R2 database servers.  There's only one method I can use to exchange information between servers: CD/DVD. The servers are far from each other (about 300 km) and the process of backing up one instance and moving data to the other and getting information back takes abut 2 days. Both database instances have the same schema, so schema synchronization is not an issue.

    One of the databases is the Master, and another has only portion of data which I call Partial. People insert records in Partial, and these records should be moved to the Master, and after some processing, the results should be transferred back to the Partial. There are more than 15 tables involved, two of them have Identity fields with different ranges set for Master and Partial. I couldn't find a way to synchronize these DBs. One of the major problems here is that data transfer can only be made using db backups and file transfer using CD/DVD. Another problem is that while the Partial data backup is on its way to the Master, we cannot stop the application to prevent new changes to Partial. The same is true about the Master.

    Is there any solution?

    Thursday, December 19, 2013 9:18 PM

All replies

  • provision both of your database (partial and master)

    provision a SQL CE database.

    sync SQL CE with master

    send SQL CE to partial site

    sync SQL CE with partial

    send SQL CE to master site

    keep the cycle going on.

    Friday, December 20, 2013 2:00 AM
  • Thank you JuneT. This sounds good. The only problem is that I may not be authorized to use another device to transfer data, only CD/DVD.

    Friday, December 20, 2013 5:55 AM
  • then copy the SQL CE database via CD/DVD.

    just copy the db to and from the cd/dvd.

    Friday, December 20, 2013 6:41 AM
  • Thank you very much!
    Friday, December 20, 2013 6:53 AM