You are here: Home > FAQ > FAQ More

How to synchronize automatically?

Before Synchronizing, you need to compare tables structures. Then the following screenshots can guide you to finish the synchronization.

Step 1: When the differences between the two data tables are found, click "Synchronize", you'll find the synchronization scripts.

synchronize_script

Step 2: Choose the data tables (dbo.data_compare), which we want to synchronize. Then a section of script code appears on the right side region. Now you can click "Sync" button to synchronize the differences.

automatically_sync

Step 3: Before synchronization, there will be a dialog popping up to remind you backup. You can select "Yes" to continue, or select "No" to backup your database manually.

backup_prompt

Step 4: Click "Yes" to continue. Then you will find that the action status of your selected table (dbo.data_compare) changed  from "Action_1" to "Action_2". This indicates that the data table from target server and source server has been synchronized.

synchronize_script

Step 5: Finally click "Compare" button, you will find the synchronized table was hidden. Thus the synchronization is completed successfully.

compared_synchronize


: When do I need to synchronize manually? And how to synchronize manually?
: How to compare the structures of two tables?


Tags: database compare   synchronize automatically  sql database synchronize  

Readers also visit these:

How to compare and synchronize the data in different database tables?
How to install Database Compare in my local disk?
How to compare and synchronize two database users?
How to compare and synchronize the differences of two database triggers?
What is date type?

Related Questions:

What is Database Integrity?
What is T-SQL (Transact-SQL)?
What is data, database (DB), DBMS and DBS?
What is role?
What is data backup and data recovery?