Using The Command Line Version

Previous  Index  Next  How To Use

The command-line executable is controlled by "switches".


The following parts are useful:

Command-line Help

Testing the Connections

Running the DataPump Process


Command-line help

The following commands show the command-line help:


dbw5_datapump -?

dbw5_datapump -h


And will output something similiar to this:


    Command Line DataPump v1.5.0

(c) 2002-2019 by Upscene Productions


    Database  Workbench v5.x

(c) 2000-2019 by Upscene Productions


Checking parameters...

No command switch found.

Usage: dbw5_datapump {-?|-h} | { {-r|-t} [options] {-input file-name-spec} }


Testing the connections

You can test the connections from the command line by using the "-t" command. The connection parameters will be taken from the input-file.


For example, you can run the following command to check two InterBase sources (available in DataPump file "mytransfer.pmp":


dbw5_datapump -t -input "c:\temp\mytransfer.pmp"

Running the above command will result in output similar to:


Checking parameters...

Testing connections ("-t" switch):

Attemping to connect to source database (seal:e:\data\serp.gdb)...

Connect and disconnect succeeded!

Attemping to connect to destination database



Destination connection failed: ISC ERROR CODE:335544721


Unable to complete network request to host "f".

Failed to locate host machine.

The specified name was not found in the hosts file or Domain Name



As you can see - the connection failed. In order to get a more detailed output, the "-v" switch was added.


Running the DataPump process

Doing the actual transfers can be done by specifying the "-r" switch and a valid DataPump file with connection parameters included.


For example, this will start the datapump:


dbw5_datapump -r -input c:\temp\pump4.pmp


You need the "-input filename" switch to include data-transfer mappings from source to destination database. Make sure to include 'command line details' when saving the file in the Data Pump.


The following options are available and can be used when running the datapump process:




-com value

-commit value

Commit the transaction in the target database after each value number of rows.



Shows output to the screen.

-o logfile

-output logfile

Logs output to logfile - you can use this to check for errors.



Without the "-v" switch, there's very little output to the screen.