Home > News > How to compare and synchronize the data in different database tables?

How to compare and synchronize the data in different database tables?

You can choose Data Comparer or Database Comparer to compare and synchronize two database tables.

Step 1: Open SQL Server Comparison Expert, click "Connection" button, then the connection dialog pops up.


Step 2: Click "Option" to open the Project Option, you can select the Object Types (Tables) to compare. Click "OK" to continue.


Step 3: Then click "OK" to finish the connection. Click "Compare" to contrast two database tables structures.


Step 4: If there are differences, you can click "Sync" to synchronize database table structure.


Step 5: Click on "Data Result", then click "Choose" to select a data table to contrast (dbo.data_compare).


Step 6: Click "" button. If there is no primary key, you can select "id", "productName" or "data_Added" columns by clicking the check-box in the popup dialog. Then click "OK" to continue. If the primary key already exists, it will skip to choose unique. Then you can compare directly.

Note: When the Unique Columns is null, click "...", you can choose some or all columns as Unique Columns in the pop-up box.

choose columns

Step 7: Click "Compare" button, the result of contrast will show you below.


Step 8: Click "Sync" to synchronize the data. The following is the data synchronization process.


Step 9: Click "Compare" button to check the result synchronization. If you couldn't find differences, thus, the synchronization is completed.


Tag: sql database compare,compare sql data,sql synchronize

Readers also visit these :

Related Questions :

Reviews & Award

  • "I love using this instead of gonig through the Microsoft wizard"

    - by John

  • "Reliable and simple to backup MSSQL, good for backup databases from one PC to another easily. "

    - by Paul