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
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 (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 |