Using The Command Line Version

Index  How To Use

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

 

The following parts are useful:

Command-line help
Testing the connections
Specifying connection parameters
Running the data generation process

 

Command-line help

The following commands show the command-line help:

 

dbw4_tdg -?

dbw4_tdg -h

 

And will output something similiar to this:

 

Command Line TestDataGenerator  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_tdg {-?|-h} | { {-r|-t} {-dbt|-dbtype dbtype} {-data|-

database database-spec} {-u|-user user-name} {-p|-password password}

[options] {-input file-name-spec} }

 

Testing the connections

You can test the connection from the command line by using the "-t" command. Please note that you should include the full connectionparameters for the database.

 

For example, you can run the following command to check a connection:

 

dbw4_tdg -t -dbt IB -data seal:e:\data\serp.gdb -u sysdba -p masterkey -v

 

Running the above command will result in output similar to:

 

Checking parameters...

Testing connection ("-t" switch):

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

Connect and disconnect succeeded!

 

In order to get this output, the "-v" (verbose) switch was added.

 

Specifying connection parameters

To specify connection parameters, use the following switches:

 

Argument

Description

-dbt

-dbtype

Database connectivity type, valid values:

IB - Borland InterBase

FB - Firebird

MSSQL - Microsoft SQL Server

MYSQL - MySQL

ORCL - Oracle Database

-data

-database

Database connect string, for InterBase or Firebird, use the full connection string, example:

seal:e:\data\serp.gdb

-u

-user

Username

-p

-password

Password

 

Running the data generation process

Doing the actual data-generation can be done by specifying the "-r" switch and valid connection parameters (see above).

 

For example, this will start the test data generator:

 

dbw4_tdg -r -dbt IB -data seal:e:\data\serp.gdb -u sysdba -p masterkey

-input c:\temp\tdg1000.tdg

 

You need the "-input filename" switch to include details on how to generate the test-data.

 

The following options are available:

 

Argument

Description

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