You are here: Home > FAQ > FAQ More

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

To compare and synchronize the differences of two database defaults, you can go through the following steps. The screenshots can be good guider for you.

Step 1: Open SQL Server Comparison Expert, click "Connection" button, then the connection dialog pop up.

connection_first

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

project option

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

Defaults_1

Step 4: You will find the differences in the compared strcture results. Click "Synchronize", you'll see the script which can make the two database defaults have no differences.

Defaults_2

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-or-not

Step 6: Click "Yes" and you will see the action status changed from "+" to "=", this told you that the synchronization has been completed successfully.

Defaults_4

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


Tags: SQL Server Comparison Expert   Defaults compare and synchronize  

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?
Which license is best for me?
What is date type?

Related Questions:

What is T-SQL (Transact-SQL)?
What is alarm manager (database)?
How to compare and synchronize the data in different database tables?
What is stored procedure?
How to compare and synchronize the schemas?