Online Documentation for DB Comparer for MySQL

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

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

Projectfile

Stands for the *.mcp 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 MySQL.

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 MySQL\MyComparerC.exe"

DBComparer_Project.mcp

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

"C:\Program Files\EMS\DB Comparer for MySQL\MyComparerC.exe"

DBComparer_MY.mcp Result.sql

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

"C:\Program Files\EMS\DB Comparer for MySQL\MyComparerC.exe"

DBComparer_MY.mcp 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 MySQL 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.