Kbase P18895: How can I migrate a Progress 7 database to another machine which has more space to dump and load it
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/09/2010 |
|
Status: Verified
GOAL:
How can I migrate a Progress 7 database to another machine which has more space to dump and load it into Progress 9 ?
GOAL:
How to migrate a database from one machine to another?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
For purposes of this solution, lets identify the machines as machine1 and machine2. Machine1 is where the database currently exists. Machine2 is where the database needs to be placed in order to dump and load into Progress 9 due to space constraints on machine1.
1. Install Progress 7.3X on other machine2.
2. Set environment variables to point to where you installed Progress 7.3X
3. Backup database on machine1 using probkup. (probkup dbname target)
4. rcp or ftp the backup file to machine2
5. Restore database backup using prorest command (prorest dbname backupfile)
6. Once restored, you can then dump the data definitions and the data using the dictionary.
7. Then set the environment variables to point to your Progress 9 installation.
8. Create a multi-volume database.
9. Then copy appropriate empty database into this new voided multi-volume database. (prodb or procopy command)
10. Then connect to the database and load the data definitions and data into this newly created Progress 9 database.