How to compare and synchronize the differences of two database user-defined Data Types?

To compare and synchronize the user-defined Data Types of two databases, just go through the following 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 (User-defined Data Types) to compare. Click "OK" to continue.

user-defined data types_option

Step 3: Click "OK" in the connection dialog, select the "Compare" button to compare the differences between the two databases user-defined Data Types.

compared_structure

Step 4: Click "Synchronize", you can find the differences of user-defined Data Types shown on the script.

Synchronize_script

Step 5: Click on "Sync", then you will be prompted to backup the target database. If you want to backup 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 user defined data types synchronization has been completed successfully.

sync_result



: How to compare and synchronize the differences of two database defaults?
: How to compare and synchronize the data in different database tables?



Tags: database compare   compare database user-defined data types   sql synchronization  

Readers also visit these:

What is data, database (DB), DBMS and DBS?
How to compare and synchronize the data in different database tables?
Which license is best for me?
Can you show me the commands in each tab in the main interface?
How to compare and synchronize two database users?

Related Questions:

What is data model?
What is Database Integrity?
What is data storage?
What is T-SQL (Transact-SQL)?