Progress
Database Administration
Guide and Reference


Using a Constant Table In Multiple Databases

You can use the Progress Dump and Load utility to copy an existing table from one database into another. For example, instead of writing a procedure to input state data into the state table in a new database, you can dump the table contents from the state table into a copy of the sports database, and then load those records into the state table in another database.

Follow these steps:

  1. Start a Progress session with the database (the source) that has the table you want to copy.
  2. Dump the contents of the table you want to copy into a contents file.
  3. Return to the Progress Procedure Editor.
  4. Switch from the current working database to the target database.
  5. With the target database as the working database, load the contents of the table.

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