Salesforce

No format change for field within Oracle Delta.sql & and delta .df via delta df progress to Oracle utility

« Go Back

Information

 
TitleNo format change for field within Oracle Delta.sql & and delta .df via delta df progress to Oracle utility
URL NameP14194
Article Number000131392
EnvironmentOracle DataServer
Progress 9.1x
OpenEdge 10.2x, 11.x
All supported platforms
Question/Problem Description
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
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
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.
Resolution
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.
Workaround
Notes
Caution: when you manually edit and load delta sql into Oracle, you are not just changing the format but the actual size of the field in Oracle. Please make sure that you understand consequences of altering an existing table in Oracle.
The reason there is no information about the format change or size change of an existing field in the delta.sql file is that Oracle allows you to increase the size of a field but to only decrease if all rows have NULL value in field. Sinc we do not require the user to be connected to ORACLE, this can not be verified.
References to Written Documentation:Progress Solution:P13836, What does the Adjust Schema option do and why use it?
Keyword Phrase
Last Modified Date9/13/2015 5:03 AM

Powered by