Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
DB2 for Linux, UNIX, and Windows Source Data Type | Synapse Analytics Target Data Type |
|---|---|
bigint | bigint |
binary( size ), 1 <= s <= 255 | binary( size ), 1 <= s <= 255 |
boolean | bit |
char for bit data | binary |
char( size ) for bit data, 2 <= s <= 255 | binary( size ), 2 <= s <= 255 |
character( size ), 1 <= s <= 255 | char( size ), 4 <= s <= 1020 |
date | date |
decfloat( precision ), 16 <= p <= 34 | varchar(255) |
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31 | decimal(p,s), 1 <= p <= 31, 0 <= s <= 31 |
double | float |
integer | int |
long varchar | varchar(max) |
long varchar for bit data | varbinary(max) |
real | real |
smallint | smallint |
time | time(0) |
timestamp( precision ), 0 <= p <= 7 | datetime2( precision ), 0 <= p <= 7 |
timestamp( precision ), 8 <= p <= 12 | char( size ), 28 <= s <= 32 |
varbinary( size ), 1 <= s <= 32672 | varbinary( size ), 1 <= s <= max |
varchar( size ) for bit data, 1 <= s <= 32672 | varbinary( size ), 1 <= s <= max |
varchar( size ), 1 <= s <= 32672 | varchar( size ), 4 <= s <= max |
