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

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 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 (User-defined Data Types) 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 databases user-defined Data Types.

Step 4: Click "Synchronize", you can find the differences of user-defined Data Types shown on the 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.

Step 6: Click "Yes" and you will see the action status changed from "

" to "

". This tells you that the user defined data types synchronization has been completed successfully.

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

Tag: database compare,compare database user-defined data types,sql synchronization

Readers also visit these :

Related Questions :

Popular articles

Reviews & Award