Kbase P12552: How to make a dump and load using the Bulkload utility
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/25/2010 |
|
Status: Verified
GOAL:
How to make a dump and load using the Bulkload utility
GOAL:
Using the Bulkloader utility to perform a dump and load of tables.
GOAL:
How to do a bulkload.
FACT(s) (Environment):
All Supported Operating Systems
Products / Versions
FIX:
ON THE DB TO BE DUMPED:
· Make a backup of the current DB.
· Dump all the table descriptions (dbname.df) using the Data Dictionary.
· Create a "Bulk Loader Description File" from the DB using the Data Admin. (dbname.fd).
· Dump the contents of the DB (one .d per table).
· If it's a multi-volume datavase or it's a V9 database, run:
prostrct list <old db>
and move the file named <old db>.st to the same directory where you are going to create the new database.
ON THE DB TO BE LOADED:
· If the new database is singlevolume (V7 or V8 only):
prodb <new db> empty
If it's a multivolume database or it's V9 use the commands:
prostrct create <new db> <old db>.st
procopy empty <new db>
· Load in the empty DB the descriptions (.df).
· Run the Bulkload in the following way:
proutil <new db> -C bulkload <.fd file>
· Build the indexes for the DB.
Please see Progress Solution 13568 and Progress Solution 16567 for further details.