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 can I get technical support?
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)?