Synchronizing Two Schemas

This topic explains how to perform simple database schema comparison and synchronization.

Comparing Schemas

  1. In the Fusion menu, point to Oracle, and then click New Schema Comparison. The New Schema Comparison wizard opens.

    New Schema Compare wizard

  2. Select the Source and Target connections. (You can edit selected connections or create a new one by either clicking the Edit button or the New button).

    To quickly compare schemas, you can click the Compare button immediately after setting databases and skip step 3.

  3. To adjust comparison process, set the comparison options.
  4. Use the Object Filter tab to select the types of objects you want to compare.

Synchronizing Schemas

  1. Analyze comparison results, select the database objects you want to synchronize by checking the corresponding check boxes.
  2. Select the data to synchronize in the grid with comparison results. (To do this, select check boxes next to tables (or views) in the top grid.

    You may also select check boxes next to individual records on the Only in Source, Only in Target, and Different Records tabs of the bottom grid).

  3. Click the Sync button Synchronize button on the Devart-Comparison toolbar to open the Schema Synchronization wizard.
  4. Select where to output the synchronization script in the wizard and then click the Synchronize button.