Using The Command Line Version

Previous  Top  Next

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:

 

dbw4_datapump -?

dbw4_datapump -h

 

And will output something similiar to this:

 

    Command Line DataPump v1.1

(c) 2002-2004 by Upscene Productions

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

    Database  Workbench v4.0.x

(c) 2000-2004 by Upscene Productions

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

Checking parameters...

No command switch found.

Usage: dbw4_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.

 

You can use the -su/-sp and -du/-dp switches to override any username/password combinations in the input-file.

 

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

 

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

 

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

 

You need the "-input filename" switch to include data-transfer mappings from source to destination database.

 

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.