Feedback
Did this article resolve your question/issue?

   

Article

How to dump and load a database using the Data Administration tool?

« Go Back

Information

 
TitleHow to dump and load a database using the Data Administration tool?
URL NameP20305
Article Number000140201
EnvironmentProduct: OpenEdge
Versions: All supported versions
OS: All supported platforms
Question/Problem Description
how to dump and load a database using data Administrator.
How to dump and load a database from dictionary?
How to ASCII dump and load a database from data dictionary?
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number
Cause
Resolution
  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.  
  1. 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.
  1. 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)
  3. After the structure has been created copy in a empty database.
  4. Procopy %DLC%\empty dbname (empty can be the desired blocksize empty1, empty2, empty4, empty8)
  1. 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.
  2. 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.
Workaround
Notes
Going to the admin menu, and choosing Dump Data and Definations, User Table Contents.  Also dump the Sequences Definations and Squences Current Values.

In the new database load the Sequence .df from the Admin, Load Data Definitions, Data Definations (df).  After that has loaded load the _user.d from the User Table Contents then load the (sequence.d) from load, sequence current values.
Last Modified Date10/7/2015 1:17 PM
Attachment 
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.