You must Sign In to post a response.
  • Category: SQL Server

    How to Synchronize data between databases


    Are you looking for a way to Synchronize data between databases ? then read this thread to know how to sync it



    Hi experts,
    in my application i have to manage 3 databases in different locations. One DB is primary and the other two are secondary. Primary DB located in head office and secondary DB's located in branch offices. branch operator insert data in their local DB (secondary). I have to synchronize data with primary DB when the network connection available or when they want to synchronize. How can i do that?
  • #756148
    There are multiple ways to sync the database,
    1. Create an executeable which will take the difference from one database and update another.
    2. SQL database server has inbuilt synchronization facility,
    1.To execute synchronization, you need to start with creating a SyncOrchestrator object and setting synchronization options such as LocalProvider, RemoteProvider, and Direction on the object.
    for more information check following link
    https://msdn.microsoft.com/en-us/library/dn266028(v=vs.103).aspx#Synchronize
    https://msdn.microsoft.com/en-us/library/dd918848(v=sql.110).aspx

    Thanks
    Koolprasd2003
    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]

  • #756332
    Dear

    Kindly go through the following mentioned links. It may help you to synchronize the data between differenr DB.

    1.http://blog.sqlauthority.com/2014/03/04/sql-server-how-to-synchronize-data-across-databases-and-servers/

    2.http://www.codeproject.com/Tips/348386/Copy-Synchronize-Table-Data-between-databases


  • Sign In to post your comments