Kbase P20888: How to migrate to a different platform and change Progress versions at the same time.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/9/2005 |
|
Status: Verified
GOAL:
How to migrate to a different platform and change Progress versions at the same time.
FIX:
The only supported method of moving between platforms is to perform a dump and load of the database, regardless of changing Progress versions. Also, Progress is only upward compatible. For example, you can dump a Progress 8 database and load it into a Progress 9 database but not vice versa.
1. Use the Data Dictionary to perform a dump of:
- Data Definitions (.df)
- Table Contents (.d)
- Create Bulk Loader Description File from the main Admin sub-menu (.fd)
and if your application uses them:
- Sequence Definitions (_seqdefs.df) # which is only necessary if you did NOT select ALL tables in the data definitions file
- Sequence Current Values (_seqvals.d)
- Auto-Connect Records (_auto.df)
- User Table Contents (_user.d)
- SQL Views (_view.d)
2. Compact with your preferred utility and then move the dumped files to the new platform.
3. Install Progress on the new platform
4. Create your void and then empty database with the planned database structure file
$ prostrct create dbname dbname.st -blocksize <num in bytes>
$ procopy DLC/empty(N) dbname # where DLC is the directory of the Progress installation and empty(N) correlates to the -blocksize value used (in KB)
5. Use the Data Dictionary to perform a load of:
- Data Definitions (.df)
- Sequence Definitions (_seqdefs.df) # if not already in the data definitions (.df)
and then the application specific dumps if needed:
- Sequence Current Values (_seqvals.d)
- Auto-Connect Records (_auto.df)
- User Table Contents (_user.d)
- SQL Views (_view.d)
6. Change to the directory where the Table Contents (.d) and Bulk Loader Description File (.fd) are, then use the PROUTIL command to load the Table Contents (.d) into the database using the "bulkload" qualifier.
$ proutil dbname -C bulkload dbname.fd
7. Rebuild all database indexes using the proutil command using the "idxbuild" qualifier.
$ proutil dbname -C idxbuild ALL -TM 24 -TB 32 -B 2048 -G 0
If you did not dump the Bulk Loader Description File then you must load the data from within the Data Dictionary rather than use the proutil command, and you would also not need to rebuild the indexes.