Compare Stored Procedures

The Comparing of Stored Procedures can be performed between homogeneous databases, i.e. between databases of same vendor. To compare the specified pair of stored procedures:

1. On both sides (trees), Connect to Database (one database on each side)
2. Expand Stored Procedures node on both Database Connections (one connection on each side)
3. On each side select the Stored Procedure you want to use

1. Right-click on the Stored Procedure name (on one of sides)
2. From the mouse menu, select Compare->Stored Procedure
   OR
   From the mane menu select Compare->Stored Procedures
   OR
   Use Compare Stored Procedures icon from the tool bar

If Comparison Options are configured to save the result to an output file, you will be asked to provide the file name. For more information, see Comparison Options

• If the Stored Procedures are identical, only the information message is returned
• If the Stored Procedures are different, Stored Procedure Differences dialog will open
  Grid contains lines with different colors:
  • Red font – different procedures
  • Blue font – definition exists only on one side
  • Black font – identical information

To become familiar with Comparison Differences dialog manipulations, see Comparison Differences dialog

• Comparison - Overview
• Data Comparison Algorithm
• Compare Table Columns
• Compare Table Structures
• Compare Primary Keys
• Compare Foreign Keys
• Compare Indexes
• Compare Data
• Comparison Differences dialog
• Compare Result of SQL Query
• Batch (mass) Comparison
• Configure and Execute Batch Comparison
• Comparison Options