Published on August 31st, 2017 | by Guest0
How to Migrate a Database from Progress 9 to OpenEdge 10
Progress 4gl migration can be as simple as compiling existing code and converting it to a database or it may be a bit complex to require an upgrade of the latest progress versions first. A number of new features and behavior changes should be taken into consideration to get the best outcome when migrating to Open Edge 10. These include:
- Open Edge10 does not support all OS platforms that were supported in previous Open Edge versions.
- Faulty OS may prevent Open Edge 10 from running
- Check with your sales department to determine which OS platforms are supported by Edge 10 and if yours is not supported seek recommendation for the preferred OS.
- Increase R-code sixe if using 16 bit offsets. The r-code can be increased by up to 45%
- Note that Open Edge 10 does not have the following features: SQL89 support, Report Builder and Active X Proxy.
Steps required to migrate a database from Progress 9 to OpenEdge 10
- Create a backup for the existing database. Before starting the migration procedure, create a backup for the Progress 9 database incase you need it
- If your database is single volume, convert it to a multivolume database
- Truncate the BI file
To truncate enter the following information in progress 9
proutil<db-name> -C truncate bi
The output of the truncation process will be proutil<db> -C conv910
- Run proutil<db> -C conv910 on open Edge 10.
The process should take less than 10 minutes for both big and small databases.
- Create a backup for the new database
When backing up the database, consider modifying the new database structure to incorporate the Open Edge 10 database features. Review the database startup parameters as follows:
- Plan the storage area so as all the tables and indexes are not in the “Schema Area”
- Decide the number of records per block for the tables that is optimal for your database structure file. “proutil<db> -C tabanalys” will give an indication of the number of records in each table.
- You can add new areas to the existing database using “prostrct add <db><db.st>”. The database hasa protuli feature with an option to reduce number of schema areas to its minimal size using “-C mvsch” utility
- Recompile the application code. Some of the 4GL statements will be deprecated
- Test to ensure that the migration to Open Edge 10.x was successful.
- Once the test is successful, review the deprecated statements to avoid issue in the future when migrating to latest version of Open Edge.
- Review the new features and implement those that are applicable.
Before embarking on a Progress 4gl migration from Progress 8 to Edge 10, take into account the considerations provided above and then follow the procedure provided. Once you have completed the application, test it and review deprecated statements and the new features accordingly.