Progress
Database Administration
Guide and Reference


Creating a Starting Version Of a Database

Suppose you finish writing an application, and your database contains not only the definitions users require to start running the application, but also the data you used to test the procedures. Before you put the application to use, you want to create a version of the database that contains only data definitions and no data. This database becomes a template you can copy for testing purposes, for your own use, and for distribution. Figure 13–4 illustrates how the Progress Database Utility (PRODB) copies the starting version of a database.

Figure 13–4: Copying the Starting Version Of a Database

To create a new database that contains table definitions from another database, use the Dump facility to dump the table definitions, the PRODB utility to create the new database, and the Load facility to load the table definitions into the new database.

Follow these steps to create a starting version of a database:

  1. Start a Progress session with the database (the source) you want to copy.
  2. Dump the database table definitions into a data definitions file.
  3. Dump the database table data into a contents file.
  4. Create a new copy of the empty database.
  5. Start a Progress session with the new database (the target) you created in Step 4.
  6. With the data definitions file you created in Step 2, load the database definitions into the new database.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095