Kbase P73729: How to perform a binary dump and load?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
GOAL:
How to perform a binary dump and load?
GOAL:
How to dump and load table contents using PROUTIL Utility?
GOAL:
How to run a binary dump
GOAL:
How to run a binary load
FACT(s) (Environment):
Progress 8.x
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
You can dump your database table contents to a binary file (called <tablename>.bd) according to the following syntax:
proutil <databasename> -C dump <tablename> <directory> [-index number]
e.g. proutil sports -C dump customer /mydir/
If you do not specify index number, the command uses primary index to dump the table.
You can load contents of a database table according to the following syntax:
proutil <dbname> -C load <filename>
e.g. proutil sports -C load /mydir/customer.bd
Please note that data definitions (.df file) has to be loaded to the target database before loading table contents from a binary file.
This is the fastest way to dump and load table contents, but it does not check the data integrity the same way as an ASCII dump does.
After performing a binary load you must re-build all indexes in the database using "-idxbuild" qualifier of the PROUTIL tool.
There are several considerations related to dumping and loading, please refer to written documentation for more information.