How to compare and synchronize the stored procedures of two databases?

To compare and synchronize the stored procedures of two databases, the following screenshots will show you the 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 (Stored Procedures) to compare. Click "OK" to continue.

stored procedures_option

Step 3: Click "OK" in the connection dialog, select the "Compare" button to compare the differences between the two database stored procedures.
Note: The function of the icon (Action_1)  is to hide the same item.

stored procedures_compare

Step 4: You will find the differences in the compared strcture results. Click "Synchronize", you can find the differences of stored procedures shown on the script.

stored procedures_synchronize


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.

stored procedures_sync

Step 7: Click "Compare" button to check the result synchronization. If you couldn't find differences, thus, the synchronization is completed.

stored procedures_compared


 


: How to compare and synchronize the differences between two database rules?
: When do I need to synchronize manually? And how to synchronize manually?



Tags: database compare   synchronize database stored procedure   compare sql databases  

Readers also visit these:

How to compare and synchronize the data in different database tables?
Can you show me the commands in each tab in the main interface?
How to compare and synchronize the permissions?
How to compare and synchronize two database users?
How to install Database Compare in my local disk?

Related Questions:

What is Database Integrity?
What is T-SQL (Transact-SQL)?
What is stored procedure?
What is data, database (DB), DBMS and DBS?
What is role?