You are here: Home > FAQ > FAQ More

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 Database Comparer, 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


: How to compare and synchronize the differences of two database user-defined Data Types?
: How to compare and synchronize the differences of two database triggers?


Tags: sql database compare   compare sql data  sql synchronize  

Readers also visit these:

What is data, database (DB), DBMS and DBS?
Which license is best for me?
Can you show me the commands in each tab in the main interface?
How to compare and synchronize the permissions?
How to install Database Compare in my local disk?

Related Questions:

What is data model?
What is Database Integrity?
What is data storage?
What is T-SQL (Transact-SQL)?