This topic gives detailed description of command-line switches and examples of their usage.
To get more information on switches related to data import through the command-line interface, type:
C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql.com /dataimport /?
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 the 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
The following information describes all switches for this option.
Use this switch to specify a connection string. Command usage looks like:
/connection:<connection_string>
Use this switch to create a new table for the imported data.
Use this switch to specify the application behavior when an error is encountered. Command usage looks like:
/errormode:<ignore | abort>
Use this switch to specify a source file, or a directory for multiple import. Command usage looks like:
/inputfile:<filepath>
Note The option is not available for the ODBC format.
Use this switch to specify the table into which data will be imported. Command usage looks like:
/inputtable:<tablename>
Note You cannot use this option to import multiple tables at once.
During import to the server, the value of the option will be generated as the table’s name in INSERT queries.
For example:
INSERT INTO my_table (column1, column2, column3) VALUES (1, 2, 3)
When importing to the SQL format, inserts will be generated to a file specified by the /singlefile parameter.
Use this switch to specify a server password in order to override the one specified in the connection string or force connecting with the specified password (when the connection string is hidden in the template file). Command usage looks like:
/password:<password>
Use this switch to specify one or several target tables. Command usage looks like:
/table <tablename> [<tablename>] /singlefile[:true|:false]
Use this switch to specify a template file. Command usage looks like:
/templatefile:<filepath>
The entire command line used to import data may look like the following;
C:\Users\User>C:\Program Files\Devart\dbForge Studio for MySQL\dbforgemysql.com" /dataimport /templatefile:"c:\Users\User\Documents\dbForge Studio for MySQL\Import\sample_template.det