You are here: Home > FAQ > FAQ More

How to compare and synchronize two database functions?

You can accomplish comparison and synchronization functions of two databases according to the  demo steps.

Step 1: Open D-Softs 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 (Functions) to compare. Click "OK" to continue.

functions_option

Step 3: Click "OK" in the connection dialog, select the "Compare" button to compare the differences between the two database functions.

functions_compare

Step 4: Click "Synchronize", you can find the differences of functions shown on the script. .

functions_synchronize

Step 5: Click on "Sync", then you will be prompted to backup the target database. If you want to backup your database manually, please choose "No" in the confirm dialog.

backup_prompt

Step 6: Click "Yes" and you will see the action status changed from "Action_1" to "Action_2". This tells you that the synchronization has been completed successfully.

functions_compared


: How to compare and synchronize two database users?
: How to compare and synchronize the differences of two database defaults?


Tags: database compare   sql compare function   synchronize sql databases  

Readers also visit these:

What is data, database (DB), DBMS and DBS?
How to compare and synchronize the data in different database tables?
Can you show me the commands in each tab in the main interface?
How to install Database Compare in my local disk?
How to compare and synchronize two database users?

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?