Online Documentation for DB Comparer for InterBase/Firebird

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

For your convenience the console version of DB Comparer for Interbase/Firebird 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 Interbase/Firebird console application>\IbComparerC.exe Projectfile [scriptfile] [logfile] [/E] [/B] [/L]

Projectfile

Stands for the *.icp 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 Interbase/Firebird.

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 Interbase & Firebird\IbComparerC.exe"

DBComparer_Project.icp

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

"C:\Program Files\EMS\DB Comparer for Interbase & Firebird\IbComparerC.exe"

DBComparer_IB.icp Result.sql

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

"C:\Program Files\EMS\DB Comparer for Interbase & Firebird\IbComparerC.exe"

DBComparer_IB.icp 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 Interbase/Firebird 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.