Compare Result of SQL Query

Compare Result of SQL Query feature allows you to compare the result of Select SQL statement (with any complexity).
Use ANSI 92 SQL standard syntax.

1. On both sides (trees), Connect to Database (one database on each side)
2. To enable SQL tab, select any object on the tree. If you select Table from the tree, you will immediately get Select statement in SQL tab, using this table.

1. Write Select SQL statements on both sides (use ANSI 92 SQL syntax)
2. On each side use Exec SQL to run the SQL statement
3. Compare the result:
   On the main menu, use Compare->SQL Queries Results
   OR
   Use Compare SQL Queries Results icon on the tool-bar

• If the compared objects have identical data, only the information message is returned.
• If the objects have different data, the Data Differences dialog will open
  Grid contains lines with different colors:
  • Red font – different data
  • Blue font – record exist only in one of the compared objects
  • 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 Stored Procedures
• Batch (mass) Comparison
• Configure and Execute Batch Comparison
• Comparison Options