EMS logo

Products Navigation

DB Comparer for MySQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS DB Comparer for MySQL

On-line Documentation

Using console DB Comparer


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

 

For your convenience the console version of Data Comparer for MySQL is included in the distribution package of the utility. The command line utility is intended for quick and powerful database structure comparison and synchronization.

 

Usage:

 

<path to Data Comparer for MySQL console application>\MyDataComparerC.exe Project_FileName [Output_FileName] [/E]

 

Project_FileName

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

 

Output_FileName

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

 

/E

Execute generated script after comparison.

 

Examples:

 

"C:\Program Files\EMS\Data Comparer for MySQL\MyDataComparerC.exe"

DBComparer_Project.mcp

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

 

"C:\Program Files\EMS\Data Comparer for MySQL\MyDataComparerC.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\Data Comparer for MySQL\MyDataComparerC.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 result of the latest task performed by Data Comparer for MySQL can be found in the system variable '%ERRORLEVEL%'.

0 - successful completion;

1 - error(s) occurred during task performing;

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

 

 



See also:

Using GUI application