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.
Step 2: Click "Option" to open the Project Option, you can select the Object Types (Full Text Catalogs) 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 database full text catalogs.
", you can find the differences of full text catalogs shown on the script.
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.
" and you will see the action status changed from "
" to "
". This tellsÂ you that the synchronization has been completed successfully.