You are here: Home > FAQ > FAQ More

How to compare and synchronize the differences of two database full text catalogs?

We'll demonstrate you how to compare and synchronize full text catalogs of two databases step by step through the screenshots below.

Step 1: Open SQL Server Comparison Expert, 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 (Full Text Catalogs) to compare. Click "OK" to continue.

full text catalogs_option

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

Full Text Catalogs_ compare

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

Full Text Catalogs_compare

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_prompt

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.

Full Text Catalogs_compared

: How to compare and synchronize the view?
: How to compare and synchronize the differences of two database roles?


Tags: compare full text catalogs  compare two databases  synchronize full text catalogs  

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 data backup and data recovery?

Related Questions:

How to compare and synchronize the data in different database tables?
How to compare and synchronize the schemas?
How to compare and synchronize contracts?
How to compare and synchronize the differences between two database rules?
How to compare and synchronize the partition functions?