Switches for data export operations from the command line

Last modified: March 28, 2025

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

Command line usage

To specify arguments, operation types, and parameters, use the command-line syntax as follows:

datapump.com /dataexport [/argfile:path] [/operation_switch] [/switch1[:value | [parameter1:value parameter2:value ..]] /switch2 ..]

To get more information on switches related to data export through the command-line interface, type:

"C:\Program Files\Devart\dbForge SQL Tools Professional\dbForge Data Pump for SQL Server\datapump.com" /dataexport /?

Available command-line switches

Switch	Usage and Action
`/connection`	Usage: `/connection:<connection_string>` Specifies the connection string.
`/errormode`	Usage: `/errormode:<ignore\|abort>`Specifies the application behavior when an error is encountered: `ignore` - ignores all errors; `abort` - cancels execution in case of an error.
`/exitcodes`	Returns the list of possible exit codes that can be returned by the command-line process.
`/outputfile`	Usage: `/outputfile:<filepath>` Specifies the destination file, or directory for multiple export. The option is unavailable for the ODBC format.
`/outputtable`	Usage: `/outputtable:<tablename>` Specifies the destination table name. The option is available for the SQL, ODBC and Access formats.
`/password`	Usage: `/password:<yourpassword>` Specifies the server password. Overrides the password specified in the connection string.
`/range`	Usage: `/range all\|<start:<startfrom> length:<count>>` Specifies the range of exported rows. `all` - allows exporting all rows; `start:<startfrom>` - allows specifying the row’s number to start exporting from; `length:<count>` - allows specifying the quantity of rows for export.
`/singlefile`	Usage: `/singlefile:<filepath>` Specifies that all data has to be exported into a single file, even if there are several source tables.
`/table`	Usage: `/table <tablename> [<tablename>]` Specifies the source table name. Several tables can be specified.
`/templatefile`	Usage: `/templatefile:<filepath>` Specifies the template file.

Worked Examples

Configure data export with settings specified in the template file.

datapump.com /dataexport /templatefile:"C:\Export\sample_template.det"

Configure data export from several tables into a single file. Connection and tables are overridden and do not match with the template.

datapump.com /dataexport /templatefile:"D:\Export_CSV.det" /connection:"Data Source=SQL_SERVER;Initial Catalog=test_db;User ID=yourusername;Password=yourpassword" /table HumanResources.Employee HumanResources.Mapping /singlefile:"D:\expdata.csv"

Configure the export of 10 records with overriding the file save path. The “Ignore all errors” error processing mode is enabled.

datapump.com /dataexport /templatefile:"D:\Export_CSV.det" /range  start:100  length:10 /outputfile:"D:\Sales_OrderTracking.csv" /errormode:ignore

The full command may look like as follows:

"C:\Program Files\Devart\dbForge SQL Tools Professional\dbForge Data Pump for SQL Server\datapump.com" /dataexport /templatefile:"C:\Export\sample_template.det"

Was this page helpful?