Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Dumping and Loading : Specialized dump and load techniques : Using a constant table in multiple databases
 
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.