Switches used in the command line

Last modified: March 28, 2025

This topic gives a detailed description of command-line switches and examples of their usage.

You can select the required options while setting the comparison in the Data Comparison wizard and generate a file with command line arguments by selecting Save settings to a file.

Access available dbForge Studio switches

To access help regarding the available command line arguments for data comparison switches, use the following command:

dbforgemysql.com /datacompare /?

Note

The path to the executable file will differ depending on how you have installed the Studio - as a standalone tool or as part of the dbForge Edge bundle. Make sure that you have specified a correct path. If you have installed the Studio as part of dbForge Edge, change the path accordingly:

C:\Program Files\Devart\dbForge Edge\dbForge Studio for MySQL>dbforgemysql.com

For more information on each command-line operation, run the following command and specify the required option value datacompare /option_name /?. For example, datacompare /report /?.

Note

To run the Command Line in Windows 11:

From the Windows taskbar

• Right-click the taskbar at the bottom of the screen and select Run. Alternatively, select Start or press Windows on the keyboard to open the Start menu.
• In the Search bar, enter cmd or Command Prompt.
• Select Command Prompt from the search results.

Using shortcut keys

• Press Windows + R to open the Run command window.
• In the window that opens, enter cmd and press Enter.

Available command-line switches

All switches of this option are described below, along with usage examples.

/compfile

Loads command line settings from the comparison project file, *.dcomp. Command usage looks like:

/compfile:<filepath>

Example of using a file with comparison settings, saved earlier:

C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql.com /datacompare /compfile:"D:\workDir\ODC1vsODC2.dcomp

/groupby

Groups objects in comparison report. Command usage looks like:

/groupby:<none/status/objecttype>

/log

Generates a comparison log to the specified file. Command usage looks like:

/log:<filepath>

The following example shows how to compare schemas using settings from the file and write log to the specified file:

C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql.com /datacompare /compfile:"ODC1vsODC2.dcomp" /log:"D:\sync.log

/meobjmask

Excludes objects from comparison if they match the given expression by using the /meobjmask argument and specifying the needed expression. To turn the option off, specify No, N, Off, False, F. Command usage looks like:

/meobjmask:<expression/N>

/micolmask

Excludes columns from the comparison if they match the given expression. To exclude columns from the comparison, specify a mask expression. To turn off the option, specify No, N, Off, False, F. Command usage looks like:

/mimask<expression/N>

/miobjmask

Includes objects to comparison if they match the given expression by using the /miobjmask argument and specifying the needed mask expression. To turn the option off, specify No, N, Off, False, F. Command usage looks like:

/miobjmask:<expression/N>

options

Specifies some comparison and synchronization options directly in the command line interface. See the list of available options and learn how to use them in the Options Used in Command Line for /datacompare topic.

/report

/reportformat

Generates schema comparison report in .html or .xls format. If you specify file format in the output file name in the /report switch, it is not necessary to use the /reportformat switch. Commands usage looks like:

/report:<filepath>

/reportformat:<HTML|XLS>

The following example shows how to compare data using settings from a file, generate report to the specified file in the HTML format:

C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql.com /datacompare /compfile:"ODC1vsODC2.dcomp" /report:"D:\report.txt" /reportformat:HTML

/includeobjects

Selects objects for the report:

• All - all objects;
• Filtered - filtered objects;
• Diff - objects with differences;
• SelectForSync - objects selected for synchronization.

Commands usage looks like:

/includeobjects:<All|Filtered|Diff|SelectForSync

The option refers specifically to the report generation in the HTML/XLS/XML formats and does not work separately from the /report:<filepath> key.

/source

Defines source database for comparison and synchronization in the command line. It is possible to use several options for defining the database.

To connect to a live database by specified parameters, type:

host:<name> database:<db> [port:<port>] user:<name> [password:<pw>] [charset:<charset>]

To specify full connection string with additional parameters, type:

connection:<connection_string>

To specify the file path to a SQL Server backup file (.bak) or backup files taken from the differential backup:

backup:<filepath> [backup:<filepath> ...]

/sync

Performs schema synchronization from the command line interface. If you specify output file for synchronization, only synchronization script will be generated. Command usage looks like:

/sync[:filepath]

The following example shows how to compare schemas using settings from the file saved before, and save synchronization script:

C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql.com /datacompare /compfile:"OSC1vsOSC2.dcomp" /sync:"D:\compare_result.sql"

/target

Specifies target database for comparison and synchronization in the command line. It is possible to use several options for defining the schema.

To connect to a live database by specified parameters, type:

host:<name> database:<db> [port:<port>] user:<name> [password:<pw>] [charset:<charset>]

To specify full connection string with additional parameters, type:

connection:<connection_string>

To specify the file path to a SQL Server backup file (.bak) or backup files taken from the differential backup:

backup:<filepath> [backup:<filepath> ...]

Note

To build the command-line syntax, it’s better to use the Command-line Wizard.