Kbase P4080: Schema difference is reported between Progress and SQL Server with Field defined as Case Insensitive
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/09/2010 |
|
Status: Unverified
SYMPTOM(s):
Check Schema utility returns differences between Progress Schema Holder and SQL Server Server Schema when there is not.
The field is defined as Case Insensitive
The field is also a part of a unique index
The difference is reported after using Progress Migration Utility
The difference between the Schema Holder and the SQL Server is reported when Verify Schema Definition is used
Example of message returned :
Differences in retainable information were detected.
These values can be modified by the Dictionary.
The schema-holder update utility does not change them.
Please use the Data Dictionary if you want to adjust them.
FIELD fld1: Case-Sensitivity:
SH: no NS: yes
FACT(s) (Environment):
Windows NT 4.0
Windows 2000
Progress 9.1D
MS SQL DataServer
CAUSE:
Bug# OE00078779
FIX:
Upgrade to OpenEdge 10.0A or later