For each supported target server, default mapping of logical data types to physical data types, and physical data types to physical data types, is provided in the Data Type Standards Editor. For example, when you migrate from Progress to SQL Server 2008, the following data type mapping is automatically performed:
|
Progress Physical Data Type |
SQL Server 2008 Physical Data Type |
|---|---|
|
CHAR |
char |
|
CHARACTER |
character |
|
DATE |
datetime |
|
DECIMAL |
decimal |
|
FLOAT |
float |
|
INTEGER |
integer |
|
LOGICAL |
bit |
|
NUMERIC |
numeric |
|
REAL |
real |
|
SMALLINT |
smallint |
Based on your selections for a source data type (Progress) and a target data type (SQL Server 2008), the default data type to which the source data type is converted displays in the SQL Server 2008 Physical Data Type column.
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |