Kbase P14243: Dsrv Progress/400: How to upgrade V7/V8 server schema to V9 server schema leaving the original schem
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/01/2005 |
|
Status: Verified
GOAL:
How to upgrade V7 server schema to V9 server schema leaving V7 server schema unchanged
GOAL:
How to upgrade V8 server schema to V9 server schema leaving V8 server schema unchanged
FACT(s) (Environment):
IBM AS/400 (RISC)
FIX:
The steps are:
Using the V9 executable library run:
1. DUPPRODB NEWDB(V9db1)
2. CVTPRODCT SRCDCTLIB(V8db) DSTDCTLIB(V9db1)
3. DUPPRODB NEWDB(V9db2) FRMDB(V9db1)
The first dup is just from empty to create the V9 Database. The second step is to convert with pulling the schema information from v8 Database into the new v9 database and the last dup will create a new v9 database and copy the schema and files into it.
CAUTION: The only problem with this method is that the Progress type attributes may be lost. If the original Database was the DB2/400 database then this is not an issue at all. If the original Database was Progress and converted to DB2/400 Database then it may be a problem.