Set-up Stored Procedures Comparison options
- Select Comparison Options from
Tools main menu.
- Go to Stores Procedures Comparison tab.
- Use check-boxes to select/unselect comparison options, according to your strategy.
Understanding Stored Procedures Comparison options:
Stored procedure Comparison is available only while using same database vendor on both sides. You can use it for different versions of the same database but not across heterogeneous databases.
- Case sensitive comparison – if you select this option, the procedure name and procedure body (if selected) will be compared according to their case. If you omit this option, the case of the stored procedure name and body doesn't affect comparison. [Default value – omitted].
- Compare stored procedure's body – if you select
this option, the text of the stored procedures will be compared. If you omit
this option, only the names of the procedures will be compared (actually,
only the "presents" of the procedure will be checked). [Default value –
selected].