Synchronizing Two Databases

Devart dbForge Data Compare for PostgreSQL allows you to compare data of databases.

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 immidiately 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 the Synchronize button on the Comparison toolbar to open the Data Synchronization wizard.

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

For more information about synchronization, refer to the Data Synchronization section.