This topic provides a detailed description of the command-line switches and their usage examples.
To get more information on switches related to data import through the command-line interface, type:
"C:\Program Files\Devart\dbForge Edge\dbForge Studio for SQL Server\dbforgesql.com" /dataimport /?
Note
The path to the executable file differs depending on how you 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 SQL Server\dbforgesql.com"
Use this switch to specify a connection string. Command usage looks like:
/connection:<connection_string>
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 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:<password>
Use this switch to specify a range of imported rows. Command usage looks like:
/range:<all|start:<startfrom> length:<count>>
The possible values and parameters for the switch are the following:
all - Imports all rows.start:startfrom - Specifies the number of the row to start import from.length:count - Specifies the quantity of rows to import.Use this switch to specify all data be imported into a single file, even if there are several source tables. Available for SQL import only. Command usage looks like:
/singlefile[:true|:false]
Use this switch to specify one or several source tables. Command usage looks like:
/table:<tablename> [<tablename>]
Use this switch to specify a template file. Command usage looks like:
/templatefile:<filepath>
The entire command line used to import data may look as the following:
"C:\Program Files\Devart\dbForge Studio for SQL Server\dbforgesql.com" /dataimport /templatefile:"C:\Users\User\Documents\dbForge Studio for SQL Server\Import\template.det"