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.