How to compare and synchronize the partition functions?

To compare and synchronize the functions of two databases, the following screenshots will show you the steps.

Step 1: Open DataBase Compare, 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 (Partition Functions) to compare. Click "OK" to continue.

partition_functions_option

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

partition_functions_compare

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

partition_functions_synchronize

Step 5: Click "Sync" to synchronize the partition functions. Then you will find the "Action" status changed from "Action_1" to "Action_2.jpg".

partition functions_sync

Step 6: Click "Structure Result", and then click "Compare" button to check the result after synchronization. If you couldn't find differences, thus, the synchronization is completed sucessfully.

partition_functions_sychronized_compare



: How to compare and synchronize the permissions?
: How to compare and synchronize the services?



Tags: sql compare function   synchronize database partition functions   sql server synchronization  

Readers also visit these:

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

Related Questions:

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