Synchronize Foreign Keys

1. Compare Foreign Keys of the specified tables. See Compare Foreign Keys
2. Analyze the compare result and decide which record(s) you want to synchronize:
   • To synchronize a single foreign key, click anywhere on the property row.
   • To synchronize all foreign keys of the table, multi-select. There are several ways to multi-select:
     1. Press Ctrl and left-click.
     2. Multi-select all the different columns on the right side by using the keyboard shortcut CTRL+A.
     3. Multi-select all the different columns on the left side by using the keyboard shortcut CTRL+A.
        NOTE: Multi-selection synchronization can only be made in one direction. The green color indicates the source record. One of the direction keys is correspondingly unavailable.
3. Determine whether you want to perform synchronizing or just create the synchronization script:
   • Press Generate SQL toolbar button to execute the synchronization immediately. In this case the created script is displayed in the text editor registered in your system as the default text editor (Notepad, in most cases). The script can be edited, saved and executed later.
   • Release Generate SQL toolbar button to create the synchronization script. In this case the synchronization is being performed immediately.
4. Click on one of the horizontal arrows indicating the direction of the synchronization.

• Synchronization - overview
• Synchronize Indexes
• Synchronize Table Structure
• Synchronize Primary Keys
• Synchronize Stored Procedures
• Discrete manual data synchronization
• Synchronize table Data
• Configure Synchronization Options
• Batch Synchronization