Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
Microsoft SQL Server Source Data Type
| Amazon Redshift Target Data Type
|
|---|---|
bigint
| bigint
|
binary( size ), 1 <= s <= 8000
| character varying( size ), 2 <= s <= 16000
|
bit
| boolean
|
char( size ), 1 <= s <= 8000
| character varying( size ), 1 <= s <= 8000
|
date
| date
|
datetime
| timestamp without time zone
|
datetime2(7)
| character varying(27)
|
datetime2( precision ), 0 <= p <= 6
| timestamp without time zone
|
datetimeoffset(7)
| character varying(67)
|
datetimeoffset( precision ), 0 <= p <= 6
| timestamp with time zone
|
decimal(38,38)
| character varying(41)
|
decimal(p,s), 1 <= p <= 38, 0 <= s <= 37
| numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
|
float
| double precision
|
geography
| character varying(65535)
|
geometry
| character varying(65535)
|
hierarchyid
| character varying(1784)
|
image
| character varying(65535)
|
int
| integer
|
money
| numeric(20,4)
|
nchar( size ), 1 <= s <= 4000
| character varying( size ), 1 <= s <= 8000
|
ntext
| character varying(65535)
|
numeric(38,38)
| character varying(41)
|
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
| numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
|
nvarchar( size ), 1 <= s <= 4000
| character varying( size ), 1 <= s <= 8000
|
real
| real
|
smalldatetime
| timestamp without time zone
|
smallint
| smallint
|
smallmoney
| numeric(10,4)
|
sql_variant
| character varying(16032)
|
text
| character varying(65535)
|
time( precision ), 0 <= p <= 7
| time without time zone
|
timestamp(8)
| character varying(16)
|
tinyint
| smallint
|
uniqueidentifier
| character(36)
|
varbinary( size ), 1 <= s <= 8000
| character varying( size ), 2 <= s <= 16000
|
varchar( size ), 1 <= s <= 8000
| character varying( size ), 1 <= s <= 8000
|
xml
| character varying(65535)
|
