Kbase P14631: Why are there differences in format between df file generate
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/23/2003 |
|
Status: Verified
GOAL:
Why are there differences in format between df file generated by protoOra and df file generated by Delta.sql Progress to Oracle utility?
GOAL:
Why are there differences in format between df generated by protoOra and df generated by delta SQL utilities?
GOAL:
Oracle DataServer
FACT(s) (Environment):
Progress 9.1x
FIX:
If you migrate a Progress database to Oracle using protoOra utility, you will get a df file created for schema holder. If you use Generate Delta.sql Progress to Oracle utility, you will get delta df file created for schema holder. There are difference between the format of df file generated by protoOra versus the format of delta df file generated by delta SQL utility.
In protoOra, the Progress database is connected so that the metaschema can be read and the SQL can be generated all at once. In the Delta SQL Utility, the delta df is read one line at a time. Therefore, the code does not know what will be created, updated, or deleted until it is read. This causes the .df and sql to have multiple statements in one file.
This difference in format will not and should not affect functionality.