SQL SERVER – How to Synchronize Data Across Databases and Servers

If you are developer you must have faced situations which I am going to mention next.

A Developer’s Wish

Have you ever built a database application where you are driving your navigation with the help of Data?

Have you ever realized that you are running query much faster on your local server, but when you move them to your test/staging server they are suddenly running slow?

Have you ever wished that you can sync your local machine with the master database so you can run your queries in your near real time scenario so you do not have surprise when you go live on production?

The matter of the fact is that every developer faces such situation when they wish that they can directly work on the live data instead of old historical data on their local machine. If an organization care about the experience of the developer and their product, they will always thrive to provide a tool which makes their developer’s life very easy.

Wish Granted

If you ask me what is a good tool which can help you to synchronize data across multiple databases and servers, I will suggest you to take a look at the DB Change Manager. It is a very powerful tool which can do quite a number of different tasks. Here are a few of your daily chores which you can rely on DB Change Manager to comply.

  • Schema Archive and Compare
  • Synchronization and Roll-back
  • Schema Auto-Synchronization
  • Data Compare and Synchronization
  • Data Masking

Click, Click and Go!

If you are a developer and given a task to make a tool to synchronize data across two different databases, how difficult it would be creating such a tool. Honestly, very difficult as we need to take care of so many different things besides data, for example – schema, configuration, security and what not. However, when we are using the Embarcadero DB Change Manager all the problems are taken care of by the tool.

If you have followed my earlier blog post about Synchronize Schema across Multiple Environment – How to Overcome Database Migration Challenge. All the steps are very similar to that demonstration. The only difference between Schema Compare and Data Compare is the very first step when we start the job. Here is the image where I demonstrate how we can start the Data Comparison Job.

SQL SERVER - How to Synchronize Data Across Databases and Servers dbdatamgr

Once you start the Data Comparison Job, it will take you to a very simple wizard with few steps. Each step is extremely easy to follow and most of the time, you just have to accept everything as a default and click on go.

SQL SERVER - How to Synchronize Data Across Databases and Servers dbdatamgr1

Once you follow the few quick steps of the wizard, you will land upon the final report page where you will notice a grid is placed with details related your change data. You can export the difference or synchronize the data across your server.

SQL SERVER - How to Synchronize Data Across Databases and Servers dbdatamgr2

That’s it!

I wish I can write more about this entire process, but as I mentioned earlier, this tool is extremely simple to use and follow. Most of the time, I just do Click, Click and Go and I am done!

You can download Embarcadero DB Change Manager from here. I am eagerly waiting for your feedback about this product.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Utility
Previous Post
SQL SERVER – Images and media file management in SQL Server and MySQL – Coding Media Management Tools is Never Easy
Next Post
SQL SERVER – SQL Report Builder in dbForge Studio for SQL Server

Related Posts

3 Comments. Leave new

  • Alf Christophersen
    March 7, 2014 12:17 am

    How do you synchronize eg. Oracle database as original with eg. a MySQL driven base?

  • Hi mate,

    I found your blog by looking for solutions to sync my local db with the server db, and the beginning of your article sound quite interesting, the continuation was not what I expected.

    I am interested to sync database from a desktop application with a server database taking in consideration the following:

    1. the application database is having the same schema like server database
    2. the application database, like the server database are small, between 20-50 mb
    3. the application can be used simultaneous from 1-100 computers in the same network
    4. I want the the sync to be done automatically when the user start the application, and refreshing as often as possible without affecting the speed of the application
    5. the database is done in MSSQL
    6. the application is done in VB
    7. the goal of the application is to present data like tables and charts, and id giving the possibility to the user to insert/update data, so I must decide to insert/update on server database or local database and then make sync in order for everybody to work with same data – what is the best way?

    Can you give me a hint? what to user? how to use?

    Thank you,

  • Can you give sql query to synchronize data between two databases with different servers?


Leave a Reply