Post reply

howto compare and synchronize db located by clients

  • April 7, 2006 at 8:58 am

    #631531

    Jan,

    There is no easy way to do this. Something needs to connect to both servers and compare the data. You could send your master db to the customers and run the comparison at each site using scripts or purchasing a tool.

    RDP is a "view" tool. A way to view the remote server. There is no way to have SQL Server read and change data through RDP.

  • April 11, 2006 at 1:17 am

    #631856

    Steve,

    That is indeed a solution. Problem with this solution (copy the master db to customer) is that we need to install the db compare/synchronize tool at the customer. This is hard to maintain and what about licences...

    It would be esier to make a data model snapshot at the customer, copy this to our server, compare and make a synchronization script, copy script to client, execute script...

    As you see not a very nice solution if you have a lot customers and a few updates a year...

    Jan

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply