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.

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.

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.

: 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)?
Technical Support
Latest News
- Can you show me the ...
- How to compare and s...
- How to compare and s...
- How to compare and s...
- How to compare and s...
- Which license is bes...
Awards
Customer Service |
| If you have any question or suggestion,please contact us. |
| Get Help>> |


