Progress
Basic Database
Tools
Binary Dump and Load
Progress allows you to move and reorganize data by performing a binary dump and load instead of an ASCII dump and load. The binary method improves the dump and load performance significantly because the data remains in binary format during the process.
Performing the Binary Dump
Use the following PROUTIL command to perform a binary dump:
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.
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:
The file header contains information that appears in this order:
When the dump procedure finishes, a screen message reports the number of records that were dumped and the number of kilobytes of data that were dumped.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |