Online Documentation for DB Comparer for PostgreSQL


All the comparison options can be saved in Project (*.pcp) files. A project file can be also used in the Console version of DB Comparer for PostgreSQL.

 

For your convenience the console version of DB Comparer for PostgreSQL is included in the distribution package of the utility. The command line utility is intended for quick database structure comparison and synchronization and further scheduling

 

Usage

 

<path to DB Comparer for PostgreSQL console application>\PgComparerC.exe Projectfile [scriptfile] [logfile] [/E] [/B] [/L]

 

Projectfile

Stands for the *.pcp file to be used as the console version execution parameter. See Opening / Saving Project for instructions on saving project files.

 

Scriptfile

Specify the output file name to save the modification script generated by the utility. If not specified, the script will be saved as Projectfile.sql in the home directory of DB Comparer for PostgreSQL.

 

Logfile

Specify the custom log file name.

 

/E

Execute generated script after comparison.

 

/L

Use the same localization in the console version as in the Wizard Application

 

/B

Use this parameter to run the application in the background mode. No console window will appear.

 

/A

Analyze renamed objects.

 

Examples:

 

"C:\Program Files\EMS\DB Comparer for PostgreSQL\PgComparerC.exe"

DBComparer_Project.pcp

Upon running the command line utility, the modification script will be generated into DBComparer_Project.sql

 

"C:\Program Files\EMS\DB Comparer for PostgreSQL\PgComparerC.exe"

DBComparer_PG.pcp Result.sql

Upon running the command line utility, the modification script will be generated into Result.sql

 

"C:\Program Files\EMS\DB Comparer for PostgreSQL\PgComparerC.exe"

DBComparer_PG.pcp Result.sql /E

Upon running the command line utility, the modification script will be generated into Result.sql and executed.

 

Note: The following exit codes can be returned by DB Comparer for PostgreSQL to the operating system after performing the latest task:

0 - successful completion;

1 - error(s) occurred during task performing;

2 - fatal error occurred. The task was not performed.