Default Data Type Mappings

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.