Progress
DataServer
for ORACLE Guide


Upgrading Schema Holders from Progress Version 7 or 8

If you have Version 7 or 8 schema holders and want to take advantage of Progress Version 9 features, make the following preparations before using the Version 9 DataServer:

  1. Start Progress Version 7 or Version 8 with the schema holder connected.
  2. Dump the data definitions (.df file) from the schema holder and move the .df file to the new client machine, if necessary. Dumping and loading a .df file is the only way to preserve any information you might have added to the schema, such as display formats, help strings, and validation expressions.
  3. Start Progress Version 9.
  4. Create and connect to an empty Version 9 Progress database.
  5. From the Data Admin main menu, choose Admin Load Data and Definitions Load Data Definitions (.df).
  6. Type the name of your .df file, then choose OK.
  7. The utility loads the .df file into the schema holder.

  8. Use the Verify ORACLE Table Definitions DataServer utility to verify the data definitions in the Version 9 schema holder.
  9. In Version 8, the DataServer did not store information in the schema holder on maximum sizes of CHARACTER and RAW columns. To make sure that the new schema holder has information on maximum size, use the Update/Add ORACLE Table Definitions utility.
  10. Recompile your r-code against the new schema holder.

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