Kbase P20305: How to dump and load a database using the Data Administration tool?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/10/2007 |
|
Status: Verified
GOAL:
how to dump and load a database using data Administrator.
GOAL:
How to dump and load a database from dictionary?
GOAL:
How to ASCII dump and load a database from data dictionary?
FACT(s) (Environment):
All Supported Operating Systems
FIX:
1.Dump the Data Definitions file.
1. Launch Data Administration.
2. From Admin Menu, Dump Data and Definitions, Data Definitions.
3. From the Select Table menu, choose the desired tables or all tables to dump.
4. Choose OK when finished.
5. When Prompted for the Output file: Browse to the desired location to store the .df file
Ensure that the Include POSITION for Compatibility is checked.
2. Dump the Table Contents.
When the dump of the df has completed.
1. Admin, Dump Data and Definitions, Table Contents(.d files)
2. Select the desired tables you wish to dump or all the tables.
3. Browse the output directory for the .d files.
4. Choose OK.
When this has completed your database has been dumped.
LOAD of DATABASE.
PRE-REQUISITES Before load.
3. To Load the database a void database structure must be created.
There are many ways to do this. Here is one.
1. Create/Modify or USE an existing structure file. database.st. (use prostrct list <dbname> to create the file if it does not exist)
2. Run prostrct create dbname dbname.st (blocksize parameter is optional)
After the structure has been created copy in a empty database.
3. Procopy %DLC%\empty dbname (empty can be the desired blocksize empty1, empty2, empty4, empty8)
4. LOAD the DATA Definitions file.
1. Launch Data Administration.
2. Goto Admin, Load DATA and Definitions, Data Definitions (.df file).
3. Browse the dumped .df file when prompted for Input file and Choose Ok.
4. When load of df is completed load the table d files.
5. Load the Tables Data files.
1. Admin, Load Data and Definitions, Table Contents (.d file)
2. Select some of the tables or all of the tables to be loaded.
3. Input the directory where the corresponding .d files are located.
When this has been completed the database has successfully been dumped and loaded.