Home > News > How to compare and synchronize two database functions?

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 SQL Server Comparison Expert, click "Connection" button, then the connection dialog pops up.


Step 2: Click "Option" to open the Project Option, you can select the Object Types (Functions) to compare. Click "OK" to continue.


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


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


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.


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.


Tag: database compare,sql compare function,synchronize sql databases

Readers also visit these :

Related Questions :

Reviews & Award

  • "I love using this instead of gonig through the Microsoft wizard"

    - by John

  • "Reliable and simple to backup MSSQL, good for backup databases from one PC to another easily. "

    - by Paul