Kbase P16049: Progress RAW fields converted to MSS CHAR datatype by Migratiing from Progress to MSS utility
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/06/2009 |
|
Status: Verified
SYMPTOM(s):
** Incompatible data types in expression or assignment. (223)
Getting error when compiling code against the MS SQL DataServer
Can not change the RAW field definitions to CHAR before converting the database.
FACT(s) (Environment):
Progress 9.1x
All Supported Operating Systems
MS SQL Server 2000
Field in Progress is defined as data type RAW
Field in schema holder is defined as as a longvarchar
Field in SQL Server is defined as as a TEXT
Database was migrated using MS SQL Server Schema Migration tools
CAUSE:
RAW datatype is not currently supported in MS SQL Server DataServer.
FIX:
Transform the TEXT column in SQL Server to BINARY. Since there's not way to convert the existing column into a BINARY, you will need to do the following:
In SQL Server
1. Delete the TEXT column
2. Create a new BINARY column
3. Pull this new column into the schema holder
4. In schema holder, this new field is a BINARY (character)
5. Write a 4GL program to populate your data into this new BINARY field.