Compare Foreign Keys

The "Compare Foreign Keys" option allows comparing foreign keys, defined for the 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 table name (on one of sides)
2. From the mouse menu, select Compare->Foreign Keys
   OR
   From the mane menu select Compare->Table/View Foreign Keys
   OR
   Use Compare Table/View Foreign Keys icon from the tool bar
   OR
   Drug one table onto another and use Compare Foreign Keys menu

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

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