Additional /dataimport Arguments

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

Arguments

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 /?

The below information describes all switches for the option.

connection

Use this switch to specify a connection string. Command usage looks like:

/connection:<connection_string>

create

Use this switch to create a new table for the imported data.

errormode

Use this switch to specify the application behavior when an error is encountered. Command usage looks like:

/errormode:<ignore ``|`` abort>

inputfile

Use this switch to specify a destination file, or a directory for multiple export. Command usage looks like:

/inputfile:<filepath>

Note The option is not available for the ODBC format.

inputtable

Use this switch to specify the table you want to import data from. Command usage looks like:

/inputtable:<tablename> 

Note You cannot use this option to export multiple tables at once.

During export to the server, the value of the option will be generated as the table’s name in INSERT queries.

For example:

INSERT INTO dbo.my_table (column1, column2, column3) VALUES (1, 2, 3)

When exporting to the SQL format, inserts will be generated to a file specified by the /singlefile parameter.

password

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 into the template file). Command usage looks like:

/password:<pw>

table

Use this switch to specify one or several source tables. Command usage looks like:

/table <tablename> [<tablename>] /singlefile[:true|:false]

templatefile

Use this switch to specify a template file. Command usage looks like:

/templatefile:<filepath>

The entire command line used to export data may look as the following:

C:\Users\User>C:\Program Files\Devart\dbForge Studio for SQL Server\dbforgesql.com" /dataexport /templatefile:"c:\Users\User\Documents\dbForge Studio for SQL Server\Export\sample_template.det