Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
Microsoft SQL Server or Azure SQL Database Source Data Type
| Microsoft Azure Synapse Analytics Target Data Type
|
|---|---|
bigint
| bigint
|
binary( size ), 1 <= size <= 8000
| binary( size ), 1 <= size <= 8000
|
bit
| bit
|
char( size ), 1 <= size <= 8000
| char( size ), 1 <= size <= 8000
|
date
| date
|
datetime
| datetime2(3)
|
datetime2( precision ), 0 <= p <= 7
| datetime2( precision ), 0 <= p <= 7
|
datetimeoffset( precision ), 0 <= p <= 7
| datetimeoffset( precision ), 0 <= p <= 7
|
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
| decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
|
float
| float
|
geography
| varbinary(max)
|
geometry
| varbinary(max)
|
hierarchyid
| varbinary(892)
|
image
| varbinary(max)
|
int
| int
|
money
| money
|
nchar( size ), 1 <= size <= 4000
| nchar( size ), 1 <= size <= 4000
|
ntext
| nvarchar(max)
|
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38
| numeric(p,s), 1 <= p <= 38, 0 <= s <= 38
|
nvarchar( size ), 1 <= size <= 4000
| nvarchar( size ), 1 <= size <= 4000
|
real
| real
|
smalldatetime
| datetime2(0)
|
smallint
| smallint
|
smallmoney
| smallmoney
|
sql_variant
| varbinary(max)
|
text
| varchar(max)
|
time( precision ), 0 <= p <= 7
| time( precision ), 0 <= p <= 7
|
timestamp(8)
| varbinary(8)
|
tinyint
| tinyint
|
uniqueidentifier
| uniqueidentifier
|
varbinary( size ), 1 <= size <= 8000
| varbinary( size ), 1 <= size <= 8000
|
varchar( size ), 1 <= size <= 8000
| varchar( size ), 1 <= size <= 8000
|
xml
| varchar(max)
|
