Release 10.1A: OpenEdge Data Management:
Database Administration

> ## Using a constant table in multiple databases

> You can use the 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.

> | To copy an existing table from one database into another:

> 1. Start an OpenEdge 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. Switch from the current working database to the target database.

> 4. With the target database as the working database, load the contents of the table.

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