Compare Indexes

The "Compare Indexes" option allows comparing indexes, defined for a specific table

1. Set-up Comparison and check SQL Vendor Specific Options
2. Check Convert Master check box (under the main tool bar) on the Source database side. See Conversion Rules
3. On both sides (trees), Connect to Database (one database on each side)
4. Expand Tables node on both Database Connections (one connection on each side)
5. On each side select the table you want to use

1. Right-click on the table name (on one of sides)
2. From the mouse menu, select Compare->Indexes
   OR
   From the mane menu select Compare->Table/View->Indexes
   OR
   Use Compare Table/View indexes icon from the tool bar
   OR
   Drug one table onto another and use Compare Indexes menu

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 Indexes, defined for tables, are identical, only the information message is returned
• If the tables have different indexes, "Indexes Differences" dialog will open
  Grid contains lines with different colors:
  • Red font – different indexes
  • Blue font – index defined only for one table or column used as a part of index 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 Data
• Comparison Differences dialog
• Compare Result of SQL Query
• Compare Stored Procedures
• Batch (mass) Comparison
• Configure and Execute Batch Comparison
• Comparison Options