Online Documentation for DB Comparer for Oracle

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

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

Projectfile

Stands for the *.ocp 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 Oracle.

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 Oracle\OraComparerC.exe"

DBComparer_Project.ocp

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

"C:\Program Files\EMS\DB Comparer for Oracle\OraComparerC.exe"

DBComparer_ORA.ocp Result.sql

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

"C:\Program Files\EMS\DB Comparer for Oracle\OraComparerC.exe"

DBComparer_ORA.ocp 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 Oracle 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.