Setting data sources

Last modified: February 3, 2025

dbForge Studio for PostgreSQL incorporates a powerful Data Compare tool for comparing and synchronizing PostgresQL database data. To start a new comparison, you need to specify two data sources you want to compare, and how to connect to them.

Start a new comparison project

To start the new data comparison, on the Comparison menu, click New Data Comparison.

Alternatively, on the Start Page, go to the Database Sync page and click New Data Comparison.

Set data sources

In the New Data Comparison wizard that opens, first you need to do is to specify two data sources you want to compare, and how to connect to them.

Under the Source and Target, in the Connection and Database dropdown lists, select the required connection and database names.

Note

After the comparison neither Source, nor Target will change. After the synchronization the Target data source will change, and the Source will remain unchanged.

To swap Source and Target settings, click

Add a new connection

To add a new database connection, in the Connection dropdown list, select Manage. Then in the Connection Manager dialog that opens, click New.

Next, on the Database Connection Properties dialog, configure the new connection settings and click Connect.

For more information, see Connect to a Database.