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.

connection

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

tables_option

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

data_compare

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

data_sync

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

data_choose

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.

data_compare

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

data_compare_processing

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

data_compared


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