Data Type Mapping - Oracle to SQL Server Migration

The reference provides detailed technical information on migrating built-in data types from Oracle to Microsoft SQL Server and SQL Azure.

Last Update: Oracle 11g Release 2 and Microsoft SQL Server 2012

All Data Types

Data types in alphabetical order:

Oracle Microsoft SQL Server
1 CLOB, > 4 GB Variable-length string VARCHAR(max), 2 GB NVARCHAR(max), 2 GB
2 DATE Date and time DATETIME DATE DATETIME2
3 INTEGER, up to 38 digits Integer NUMERIC(38) BIGINT INT
4 NCLOB, > 4 GB Variable-length Unicode string NVARCHAR(max), 2 GB
5 RAW(n), 1 ⇐ n ⇐ 2000 Variable-length binary VARBINARY(n), 1 ⇐ n ⇐ 8000
Different SQL INSERT syntax
6 VARCHAR2(n), 1 ⇐ n ⇐ 4000 Variable-length string VARCHAR(n), 1 ⇐ n ⇐ 8000

Large-Object Data Types

Large-object (LOB) data types conversion:

Oracle Microsoft SQL Server
1 CLOB, > 4 GB Variable-length string VARCHAR(max), 2 GB NVARCHAR(max), 2 GB
2 NCLOB, > 4 GB Variable-length Unicode UTF-8 or UTF-16
string
NVARCHAR(max), 2 GB