Changes to field FORMAT are not reflected in delta .df / .sql files generated by DataServer products

Changes to field FORMAT are not reflected in delta .df / .sql files generated by DataServer products

Errors recorded in .e file after running Generate Delta sql OpenEdge to MS SQL utility.

These messages are not seen when running delta utility in Progress 9.1D and lower.

This is an informational message; it does not indicate an error. The "OpenEdge DB to ..." utilities convert Progress data types to corresponding foreign data types according to the Format definition during an initial migration session. Delta SQL Progress to SQL Server ignores the Format change over existing fields.
 

Upgrade to OpenEdge 11.4 or later.
 

To migrate the change to MS SQL Server and the schema holder, make manual changes in the generated delta.sql file, load the delta SQL into MS SQL Server, then migrate the change to schema holder.

There are 2 ways to accomplish it:

1) Manually edit the delta.sql file to change the size of the field, load the SQL into MSS
2) Connect to both schema holder and modified MSS  database. Use Add/update table definitions utility to update the affected tables.
3) Connect to the 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 MSS.
2) Recreate an empty database, do a complete schema pull of all the tables from MSS.
3) Connect to the original progress database and schema holder, Adjust Schema against all the tables.

 

Caution: when manually editing and loading a delta sql into MS SQL, the actual size of the field is being adjusted. Please be sure to understand the consequences of altering an existing table in Microsoft SQL Server.


References to other documentation:

Progress Article(s):
No format change for field within Oracle Delta.sql & and delta .df via delta df progress to Oracle utility