The following table illustrates the default Oracle data types to which the source MS SQL Server and Sybase data types are converted by the Migration Workbench.
|
MS SQL Server/Sybase Data Type |
Oracle Data Type |
|
Binary |
RAW(255) |
|
Bit |
NUMBER(1, 0) |
|
Char |
CHAR() |
|
Datetime |
DATE() |
|
Datetimn |
DATE() |
|
Decimal |
NUMBER(0, 0) |
|
Decimaln |
NUMBER(0, 0) |
|
Float |
FLOAT(0) |
|
Floatn |
FLOAT(0) |
|
Image |
BLOB() |
|
Int |
NUMBER(10, 0) |
|
Intn |
NUMBER(0, 0) |
|
Money |
NUMBER(19, 4) |
|
Moneyn |
NUMBER(19, 4) |
|
Nchar* |
CHAR() |
|
Ntext |
CLOB() |
|
Numeric |
NUMBER(0, 0) |
|
Numericn |
NUMBER(0, 0) |
|
Nvarchar* |
VARCHAR2() |
|
Real |
FLOAT(24) |
|
Smalldatetime |
DATE() |
|
Smallint |
NUMBER(5, 0) |
|
Smallmoney |
NUMBER(10, 4) |
|
Sysname |
VARCHAR2(128) |
|
Text |
CLOB() |
|
Timestamp |
NUMBER(0, 0) |
|
Tinyint |
NUMBER(3, 0) |
|
Varbinary |
RAW(255) |
|
Varchar |
VARCHAR2() |
*The NVARCHAR and NCHAR data types do not exist in MS SQL Server 6.5.
Refer to Oracle8i Data Types and the Options dialog box for more information about data types.