The command-line executable is controlled by "switches".
The following parts are useful:
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.
|