Additional /dataexport 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 export through the command-line interface, type:

"C:\Program Files\Devart\dbForge Studio for Oracle\dbforgeoracle.com" /dataexport /?

Note

The path to the executable file will differ depending on how you have installed the Studio - as a standalone tool or as part of the dbForge Edge bundle. Make sure that you have specified a 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 Oracle>dbforgeoracle.com

connection

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

/connection:<connection_string>

errormode

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

/errormode:<ignore | abort>

outputfile

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.

outputtable

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

range

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 - type to export all rows
  • start: - type to specify the number of the row to start export from
  • length: - type to specify the quantity of rows to export

singlefile

Use this switch to specify all data be exported into a single file, even if there are several source tables. Available for SQL export only. Command usage looks like:

/singlefile[:true|:false]

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 Oracle\dbforgeoracle.com" /dataexport /templatefile:"c:\Users\User\Documents\dbForge Studio for Oracle\Export\sample_template.det

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?