You may easily compare two PostgreSQL databases, discover the similarities or differences in their structure, as well as synchronize certain tables.
- EMS DB Comparer for PostgreSQL
- Version :4.4.0 Build 49659
- License :Trial
- OS :Windows All
- Publisher :EMS Software Development
EMS DB Comparer for PostgreSQL Description
EMS DB Comparer for PostgreSQL is a reliable tool that facilitates the comparison of two PostgreSQL databases. The tool can connect to two PostgreSQL databases stored on the same server or in separate locations and easily identify the differences or similarities between them.
Connect to local hosts or remote servers
EMS DB Comparer for PostgreSQL supports reading information from PostgreSQL databases regardless if they are stored on local or remote servers. Each comparison process can be performed within a project, which is configured with the connections to the databases. You need to specify these details in the dedicated wizard window.
The program supports SSL tunneling functions, which you can configure if required, for a secure connection. The program can perform a full database comparison or a schema to schema analysis.
You may customize the comparison, even select the objects you wish to exclude from the process. For example, a comparison task can analyze schemas, tablespaces, languages or event triggers.
Identify differences between schemas
EMS DB Comparer for PostgreSQL allows you to find the differences and similarities between the selected schemas, by analyzing certain objects. The structure includes aggregated objects, domains, functions, operators, sequences, tables, types, composite/enum/range types, views and collations.
The main workspace in EMS DB Comparer for PostgreSQL is split into several areas so that you can view the details of the comparison in parallel. You can extend the tree structure and analyze the results of the comparison for individual nodes. The tool also includes an SQL script editor, that allows you to further customize the comparison process.
Compare and synchronize objects
Quickly analyze the differences and similarities between two PostgreSQL databases with EMS DB Comparer for PostgreSQL. Moreover, you can copy the definition of any selected object, from either database to the clipboard or synchronize the information in the two locations. The sync process can be performed for each object in the schemas.