Salesforce

How to perform a binary dump and load?

« Go Back

Information

 
TitleHow to perform a binary dump and load?
URL NameP73729
Article Number000189522
EnvironmentProduct: Progress
Version: 8.x, 9.x
Product: OpenEdge
Version: All Supported Versions
OS: All Supported Platforms
Question/Problem Description
How to perform a binary dump and load?
How to dump and load table contents using PROUTIL Utility?
How to run a binary dump
How to run a binary load
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
Dump the 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 and index number is not specified, the command uses primary index to dump the table.

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

If there are multiple .bd files for one table (.bd, .bd2, .bd3 ....) then load each file separately.

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 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.
Workaround
Notes
References to Other Documentation:
System Administration Guide for version 8:
Chapter 13: "Dumping and Loading"

Database Administration Guide and Reference for version 9,
Chapter 13: "Dumping and Loading"
Chapter 19: "Database Administrator utilities", "PROUTIL Utility"

OpenEdge Data Management: Database Administration Guide,
Chapter 9: "Dumping and loading"
Chapter 15 "Database Administrator utilities", "PROUTIL Utility"

Progress Article(s):
000001108, "How to dump and load the database the fastest way?"
000021635, How to run idxbuild the fastest way?
Keyword Phrase
Last Modified Date12/6/2023 8:46 PM

Powered by