Using The Command Line Version

Previous  Top  Next

The command-line executable (dbw_datapump.exe) 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: dbw_datapump -? dbw_datapump -h And will output something similiar to this:      Command Line DataPump v1.1 (c) 2002-2004 by Upscene Productions ------------------------------------      Database  Workbench v2.5.x (c) 2000-2004 by Upscene Productions ------------------------------------ Checking parameters... No command switch found. Usage: dbw_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": dbw_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: dbw_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.