Consultor Eletrônico

Status: Unverified

GOAL:

What are the steps to do dump and load with a runtime or database server license using binary dump/load

GOAL:

How to perform a binary dump/load using only runtime license

FACT(s) (Environment):

All Supported Operating Systems
Progress 8.2x
Progress 8.3x
Progress 9.x
OpenEdge 10.x

FIX:

1. Start progress client session with -rx startup option and connect the database.

2. Dump the data definitions by going into the Data dictionary (Unix) or Data Administration (Windows) -> Admin -> Dump Data and Definitions -> Select Data Definitions from the pull down menu.
Select tables you wish to dump the definitions for. Then press F1 to execute (Unix) or F2 to execute (Windows). Enter name of file you want information sent to. Then select ok and definitions will be dumped.

3. For every table you want to perform a binary dump to dump the data.
Syntax: proutil dbname -C dump tablename dir (this will create a tablename.bd in your working directory)

4. Create new db (prostrct create dbname dbname.st or use prodb <database name> empty)

5. If you used prodb in step 4 you can skip this step. Copy empty database into that newly created void database using procopy command.

6. Start Progress client session with -rx option and connect the newly created database.

7. Enter the Data Dictionary and load the .df. Go into the dictionary -> Admin -> Load Data and Definitions -> Enter input file where the definitions are located. Then select ok and definitions will be loaded. The database trigger definitions are part of the .df file, thus do not need to be re-defined.

8. To load the data you dumped in step 3, you will need to perform a binary load for each table you dumped.

Syntax: proutil <dbname> -C load <binaryfile name (.bd)>

9. Run proutil idxbuild with optiion all to build index:

Syntax: proutil <dbname> -C idxbuild all -TB 24 -TM 32