Setting data sources

dbForge Schema Compare for PostgreSQL gives you a perfect opportunity to compare and synchronize schemas with many useful features. To start a new comparison project, you need to specify two data sources you want to compare, and how to connect to them.

To select Source and Target connections and specify the names of databases to be compared:

1. On the File menu, click New Schema Comparison.

2. In the New Schema Comparison wizard that opens, specify the type of the Source and Target, connection and the names of the databases to be compared.

Postgres Schema Compare - Setting sources

Selecting data sources

Select the two data sources you want to compare in the Source and Target tab of the New Schema Comparison wizard. You need to specify a source and a target.

Note:

The Source is the data source that will not change. The Target is the data source that will change.

To swap Source and Target settings click Swap Source and Target Settings Postgres Schema Diff - Swapping sources.

Schema Compare for PostgreSQL only supports the comparison of databases.

Selecting Source and Target

1. Select the PostgreSQL Server in the Connection box.

Note:

If you need to use a new connection:

  1. Click < Manage… > in the drop-down list under Connection.
  2. Then in the Connection Manager window, click New.

Postgres sync databases - New connection

3. Finally, in the Database Connection Properties window specify the details of the connection you want to add.

PostgreSQL compare two database schemas - Database Connection Properties

Alternatively, click the New button in the New Schema Comparison Wizard.

PostgreSQL synchronize databases - New button

2. Select a database to be compared from a drop-down list under Database.

To refresh the Database list, click < Refresh… > option at the top of the list.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Schema Compare for PostgreSQL.
Ready to start using dbForge Schema Compare for PostgreSQL?