Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
Netezza Source Data Type | Synapse Analytics Target Data Type |
|---|---|
bigint | bigint |
boolean | bit |
byteint | smallint |
char( size ), 1 <= s <= 8000 | char( size ), 1 <= s <= 8000 |
char( size ), 9000 <= s <= 64000 | nvarchar(max) |
date | date |
double | float |
integer | int |
interval | varchar(55) |
nchar( size ), 1 <= s <= 3100 | nchar( size ), 1 <= s <= 3100 |
nchar( size ), 4100 <= s <= 16000 | nvarchar(max) |
numeric(p,s), 1 <= p <= 38, 1 <= s <= 38 | decimal(p,s), 1 <= p <= 38, 1 <= s <= 38 |
nvarchar( size ), 1 <= s <= 16000 | nvarchar( size ), 1 <= s <= max |
real | real |
smallint | smallint |
st_geometry( precision ), 1 <= p <= 63001 | varbinary( size ), 1 <= s <= max |
time | time(6) |
timestamp | datetime2(6) |
timetz | datetimeoffset(6) |
varbinary( size ), 1 <= s <= 64000 | varbinary( size ), 1 <= s <= max |
varchar( size ), 1 <= s <= 64000 | varchar( size ), 1 <= s <= max |
