Database Ingestion and Replication

Back Next

Microsoft SQL Server Source and Oracle Target

The following table identifies the recommended data-type mappings for

configurations with a Microsoft SQL Server source and an Oracle target:

Microsoft SQL Server Source Data Type	Oracle Target Data Type
bigint	number(19)
binary(`size`), 1 <= size <= 2000	raw(`size`), 1 <= size <= 2000
binary(`size`), 2001 <= size <= 8000	blob
bit	char(1 char)
char(`size`), 1 <= size <= 2000	char(s char), 1 <= size <= 2000
char(`size`), 2001 <= size <= 4000	varchar2(s char), 2001 <= size <= 4000
char(`size`), 4001 <= size <= 8000	clob
date	date
datetime	timestamp(3)
datetime2(0)	date
datetime2(`precision`), 1 <= p <= 7	timestamp(`precision`), 1 <= p <= 7
datetimeoffset(`precision`), 0 <= p <= 7	timestamp(`precision`) with time zone, 0 <= p <= 7
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38	number(p,s), 1 <= p <= 38, 0 <= s <= 38
float	binary_double
geography	blob
geometry	blob
hierarchyid	blob
image	blob
int	number(10)
money	number(19,4)
nchar(`size`), 1 <= size <= 1000	nchar(s char), 1 <= size <= 1000
nchar(`size`), 1001 <= size <= 2000	nvarchar2(s char), 1001 <=size <= 2000
nchar(`size`), 2001 <= size <= 4000	nclob
ntext	nclob
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38	number(p,s), 1 <= p <= 38, 0 <= s <= 38
nvarchar(`size`), 1 <= size <= 2000	nvarchar2(s char), 1 <= size <= 2000
nvarchar(`size`), 2001 <= size <= 4000	nclob
real	binary_float
smalldatetime	date
smallint	number(5)
smallmoney	number(10,4)
sql_variant	blob
text	clob
time(`precision`), 0 <= p <= 7	timestamp(`precision`), 0 <= p <= 7
timestamp(8)	raw(8)
tinyint	number(3)
uniqueidentifier	char(36 char)
varbinary(`size`), 1 <= size <= 2000	raw(`size`), 1 <= size <= 2000
varbinary(`size`), 2001 <= size <= 8000	blob
varchar(`size`), 1 <= size <= 4000	varchar2(s char), 1 <= size <= 4000
varchar(`size`), 4001 <= size <= 8000	clob
xml	clob

LOB limitations

Database ingestion and replication

initial load jobs can replicate data from SQL Server GEOGRAPHY, GEOMETRY, IMAGE, NTEXT, NVARCHAR(MAX), TEXT, VARBINARY(MAX), VARCHAR(MAX), and XML columns to Oracle targets. LOB data might be truncated before being written to the target. For all of the LOB data types, the truncation point is 16777216 bytes. For more information, see the "Include LOBs" description in Configuring the source.

Unsupported source data types

None.

Default Data Type Mappings

Download Guide

Watch

Comments

Cloud Mass Ingestion Homepage