Kbase 20013: How to Load a V8 Schema (.df file) in a V9 Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/8/2008 |
|
Status: Verified
GOAL:
How to load a Progress 8.x schema (.df) into a Progress 9.x database.
FIX:
It is important to note that the Progress 9.x .df files are slightly different from the Progress 8.x .df file. This solution compares part of a version 8.x .df file to a Progress 9.x .df file from the Sports database showing information for the table called "Invoice".
The Progress 8.s file:
ADD TABLE "Invoice"
DESCRIPTION "This contains transactions for the Receivables system"
DUMP-NAME "invoice"
TABLE-TRIGGER "CREATE" NO-OVERRIDE PROCEDURE "sports/crinv.p" CRC ?"
TABLE-TRIGGER "DELETE" NO-OVERRIDE PROCEDURE "sports/delinv.p" CRC
"?"
The Progress 9.x file:
ADD TABLE "Invoice"
AREA "Info Area"
DESCRIPTION "This contains transactions for the Receivables system"
DUMP-NAME "invoice"
TABLE-TRIGGER "CREATE" NO-OVERRIDE PROCEDURE "sports/crinv.p" CRC "?
"
TABLE-TRIGGER "DELETE" NO-OVERRIDE PROCEDURE "sports/delinv.p" CRC
"?"
Notice the second line. The line shows that the table "Invoice" is located in the area called "Info Area". If you do not create areas in your Version 9.x database, all data is stored in the "Schema Area".
If this is the case, you still must list this area in the .df file as in the following example:
ADD TABLE "Invoice"
AREA "Schema Area"
DESCRIPTION "This contains transactions for the Receivables system"
DUMP-NAME "invoice"
TABLE-TRIGGER "CREATE" NO-OVERRIDE PROCEDURE "sports/crinv.p" CRC "?
"
TABLE-TRIGGER "DELETE" NO-OVERRIDE PROCEDURE "sports/delinv.p" CRC
"?"
The AREA must also be removed from the ADD INDEX section of the .df file.