Try OpenEdge Now
skip to main content
Basic Database Tools
Table Tasks : Binary dump and load : Performing the binary dump
 

Performing the binary dump

Use the following PROUTIL command to perform a binary dump:
proutil dbname -C dump tablename directory [ -index num ]
db-name
Specifies the database from which you want to dump. You must completely define the path.
tablename
Specifies the name of the table containing the data you want to dump.
directory
Specifies the name of the target directory into which the data will be dumped.
-index num
Specifies an index with which to dump the table's contents. If you choose not to use this option, the command uses the primary index to dump the table.
Note: Additional parameters to PROUTIL DUMP are available for security (encryption) and performance.
PROUTIL DUMPSPECIFIED provides the ability to dump portions of a table based on specified selection criteria.
Note: For a complete descriptions and syntax, see OpenEdge Data Management: Database Administration.
The dump command writes the data to a dump file named table.bd, where table is the name of the table that was dumped. For example, if you dump data from the table named "customer," the procedure creates a dump file named customer.bd in the directory you specify in the command.
Each binary dump file contains a header and a description for each record in the table. The dump file appears in the following format:
Header
Record length
Table number
Binary record
Record CRC
The file header contains information that appears in the following order:
*Version number
*Date and time the file was created
*Name of the table being dumped
*Number of the table being dumped
*CRC of the table being dumped
*Number of fields in the table
*Name of the database in which the table resides
*Section number
*Number of the first record
When the dump procedure finishes, a screen message reports the number of records and the number of kilobytes of data that were dumped.