Synchronizing Two Databases

Note

When you select the Source and Target, the sync operation only applies changes to the target database, while the source database keeps unchanged.

Database Connection Setup

1. Click New Data Comparison on the Start Page. The New Data Comparison wizard opens.

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 data, you can click the Compare button immediately after setting databases and skip step 3.

3. If you want to change default comparison settings, go to the Options and Mapping tabs of the New Data Comparison wizard.

Synchronization Script Generation

1. 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).

2. Click Right pointing arrow on the Comparison document to open the Data Synchronization wizard.

3. Select where to output the synchronization script in the wizard and then click the Synchronize button.