This topic gives a detailed description of command line switches and provides the examples of their 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 /?
| 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. |
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"