This topic gives detailed description of command line switches and examples of their usage.
To get more information on switches related to schema comparison in the command line interface, you can type:
"C:\Program Files\Devart\dbForge Studio for MySQL\dbforgemysql.com" /schemacompare /?
Below all switches of this option are described, together with usage examples.
Switch | Usage |
---|---|
compfile | Use this switch to load command line settings from comparison .scomp project file. Command usage looks like: /compfile:<path> . |
exitcodes | Use this switch to get the list of possible exit codes that can be returned by the command-line process. |
filter | Use this switch to apply a custom filter to include or exclude objects from comparison. Command usage looks like: /filter:<filepath> . |
includeobjects | Use this switch to specify objects that will be included into the report: All - all objects; Filtered - filtered objects; Diff - objects with differences; SelectForSync - objects selected for synchronization. Command usage looks like: /includeobjects:<All|Filtered|Diff|SelectForSync> . |
log | Use this switch to generate a comparison log file in a specified directory. Command usage looks like: /log:<filepath> . |
options | Use this switch to specify a value for a comparison or synchronization option. To turn on the option, specify: Yes , Y , On , True , T . To turn off the option, specify: No , N , Off , False , F . Command usage looks like: /{option}:[value] . You can use this switch as many times as many options you want to specify. For more information, see Options used in the command line. |
report | Use this switch to generate a comparison report file. If the output file name has .html, .xls or .xml extension, it’s not necessary to specify the file format - it will be chosen depending on the extension. Command usage looks like: /report:<filename> . |
reportformat | Use this switch to specify a format of a file comparison report: HTML - a simple HTML file; XLS - a simple Microsoft Excel file; XML - a simple XML file; XMLFOREXCEL - a simple XML file for Microsoft Excel. If the format was not specified, it is determined by the extension of the report file. Command usage looks like: /reportformat:<HTML|XLS|XML|XMLFOREXCEL> . |
source | Use this switch to specify source with the following options: host:<name> database:<db> [port:<port>] user:<name> [password:<pw>] [charset:<charset>] - connects to a live database by specified parameters. connection:<connection_string> - allows specifying the full connection string with additional parameters. |
sync | Use this switch to launch database synchronization. If an output file path is specified, the program will generate only a synchronization script. Command usage looks like: /sync[:path] . |
target | Use this switch to specify target with the following options: host:<name> database:<db> [port:<port>] user:<name> [password:<pw>] [charset:<charset>] - connects to a live database by specified parameters. connection:<connection_string> - allows specifying the full connection string with additional parameters. |