Kbase P19842: How to dump a database using a personal database license?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/01/2005 |
|
Status: Unverified
GOAL:
How can I dump a database using a personal database license?
GOAL:
How to dump and load a Personal Database.
FACT(s) (Environment):
Progress 9.x
FIX:
HOW TO DUMP A PERSONAL DATABASE:
1. Connect to database using the -rx parameter.
Example: pro dbname -p _admin.p -rx
2. Dump the Data Definitions (df) file.
From Data Administration, Admin, Dump Data and Definitions, Data Definitions(df file).
After completion exit and shutdown the database server if running.
3. Binary dump the database tables.
proutil dbname -C dump Tablename pathtodbfile
4. Continue step 3 Until all the tables you wish to dump have been dumped.
Open the df file and search for Add Table to determine the table names of the database if need be.
HOW TO LOAD A PERSONAL DATABASE:
This directions assume that the database structure has already be created, and a void structure has been copied into the new database.
1. Connect to the database using the rx parameter.
example: pro dbname -p _admin.p -rx
2. Load the data definitions file.
From Data Administration, Admin, Load Data and Definitions, Data Definitions (.df file)...
A. Enter the path and file name of the .df file that you wish to load for the Input File: field.
B. Choose the appropriate error condition.
OK to start the load.
When the load has finished exit out.
3. Load the table.bd files into the database.
example: proutil dbname -C load C:\temp\TableName.bd
4. Continue step 3 until all tables are loaded.
5. After the load is complete rebuild the database Indices.
example: proutil dbname -C idxbuild