This topic provides a detailed description of the command-line switches and their usage examples.
To get more information on switches related to data export through the command-line interface, type:
"C:\Program Files\Devart\dbForge Studio for SQL Server\dbforgesql.com" /dataexport /?
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. If you installed the Studio as part of dbForge Edge, use the following path:
"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 destination file, or a directory for multiple export. Command usage looks like:
/outputfile:<filepath>
Note
The option is not available for the ODBC format.
Use this switch to specify a destination table name for SQL, ODBC and Access formats. Command usage looks like:
/outputtable:<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.
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 exported rows. Command usage looks like:
/range:<all|start:<startfrom> length:<count>>
The possible values and parameters for the switch are the following:
all - Exports all rowsstart:startfrom - Specifies the number of the row to start export fromlength:count - Specifies the quantity of rows to exportUse this switch to export all data into a single file, even if there are several source tables. This option is available for SQL export 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 export data may look as the following:
"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"