Kbase P4081: Data not migrated when using MSS Migration Utilities
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Windows 2000
FACT(s) (Environment):
Windows NT 4.0
SYMPTOM(s):
Data not migrated when using MSS Migration Utilities
MSS SQL Server Migration Utilities
Field is Case sensitive
Ascending Index
Unique Index
Same data in database in upper and lower case
Lower case data not migrated
Descending Index
Upper case data not migrated
Cannot Insert duplicate key row in object '<tableName> with unique index '<indexName>"
Inserting a new record from PROGRESS
MSS SQL Server DataServer
SQL Server 7
CAUSE:
Code Page is defined as Case Insensitive on SQL Server Database
FIX:
Change the SQL Server Code Page to be Case Sensitive