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

------------------------------------

Database Workbench v5.x

------------------------------------

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

(iduna:f:\interbasedata\serp.gdb)..

Destination connection failed: ISC ERROR CODE:335544721

ISC ERROR MESSAGE:

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

Services.

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:

Argument	Description
-com value -commit value	Commit the transaction in the target database after each value number of rows.
-v -verbose	Shows output to the screen.
-o logfile -output logfile	Logs output to logfile - you can use this to check for errors.

Note:

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