Kbase P14194: No format change for field within Oracle Delta.sql & and delta .df via delta df progress to Oracle u
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
Progress 9.1B
Progress 9.1C
Progress 9.1D
SYMPTOM(s):
When there is format change for any data types such as DECIMAL, CHAR, etc in delta df for Progress database, delta SQL Progress to Oracle does not reflect the change
The Delta.df generated has no modification for the format change of the affected field
The Delta.sql generated has no size modification for the corresponding column in Oracle
CAUSE:
This is expected behavior. "Protoora" converts Progress data types to corresponding oracle data types according to the Format definition during an initial protoora (option "Progress DB to ORACLE..") . Delta SQL Progress to Oracle ignores the Format change over existing fields.
FIX:
If you'd like to migrate the change to Oracle and schema holder, make manual changes in the generated delta SQL file, load the delta SQL into Oracle, then migrate the change to schema holder.
There are two ways to accomplish it:
1. Manually edit the delta.sql file to change the size of the field, load the sql into Oracle
2. Connect to both schema holder and modified Oracle database. Use Add/update table definitions utility to update the affected tables
3. Connect to original Progress database and schema holder, run Adjust Schema utility against affected tables.
or
1. Manually edit the delta.sql file to change the number field, load the
sql into Oracle
2. Recreate an empty database, do a complete schema pull of all the tables from Oracle
3. Connect to original progress database and schema holder, Adjust Schema against all the tables.