Release 10.1A: OpenEdge Deployment:
Managing 4GL Applications

> ## Upgrading with time-stamp-based r-code files

> If database changes are extensive, you might choose to distribute brand new versions of your application and the database.

> | To distribute the precompiled version of an upgraded database:

> 1. Build a new basic database.

> 2. Recompile all your procedures, including those not directly affected by the schema change, so that r-code file time-stamps match the database file time-stamps.

> 3. Distribute the new basic database and the recompiled procedures to users.

> Your users will have to dump their data from the old database and load it into the new database. Therefore, you must also provide your users with a dump/reload facility.

> 4. If you are changing any of the file formats used in your application, you must modify the set of load files to work with those new formats.

> 5. Run the mkdump script against the new version of the database.

> 6. Supply a modified set of file load procedures so the user can reload the database using procedures that are compatible with the old data format. These procedures will probably be different from the file load procedures the user will use to reload the new database after dumping it.

> 7. Supply new file dump, file load, and subdirectory procedures so the user can later dump and reload the database, if necessary.

> | To incorporate modifications you made to the database, the user must:

> 1. Use the old dump procedure to dump the data in the existing database. (Note that dumping and reloading a large database might take days, depending on the database size.)

> Note: You can use the binary dump and load to reduce this time dramatically. See the section on `PROUTIL` in OpenEdge Data Management: Database Administration for more information on binary dump and load.

> 2. Make a copy of the new basic database.

> 3. Use the new load procedure to load the old database data into the new database. You must ensure that the new load procedure is prepared to accept data in the format and order dumped by the old dump procedures.

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