Re: SQL dump?

[S Dierkes]

For dumping use script like:

loadercli -d mydb -u dba,dba -b exportdata

where exportdata is a configuration file:

CATALOGEXTRACT USER OUTSTREAM FILE '[some path]\mydb_cat'
//
TABLEEXTRACT USER DATA OUTSTREAM FILE '[some path]\mydb_data' RECORDS

The first line will extract the catalog (i.e. table definitions, etc.) the next command line will extract the data.
Since I usually use sqlstudio to create the tables, I edit the file mydb_cat and load it from the sqlstudio. To load the data use something like:

loadercli -d copy_db -u dba,dba -n 192.168.178.17 -b uploaddata

In this case the data is loaded to a remote db and uploaddata is a command script:

TABLELOAD USER DATA INSTREAM FILE '[some path]\mydb_data' RECORDS

You might change in both command scripts the parameter "USER" (see docs).

In case of "USER" it's important that the user exists on the copy db.



Edited 1 time(s). Last edit at 06/14/2006 03:27AM by S Dierkes.