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:

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.

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 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