Data Type Mapping for Azure SQL Database - DSS 6 | Data Source Solutions Documentation

Documentation: Data Type Mapping for Azure SQL Database - DSS 6 | Data Source Solutions Documentation

Data Type Mapping for Azure SQL Database

This section lists the mapping of data types for Azure SQL Database.

Azure SQL Database as Source

When Azure SQL Database is used as a source location, following is the mapping of data types in Azure SQL Database to the corresponding Data Source Solutions DSS repository data type.

Azure SQL Database	Capture Support	Repository Data Type
int	Native	int
bigint	Native	bigint
smallint	Native	smallint
tinyint	Native	tinyint
numeric	Native	numeric
decimal	Native	numeric
bit	Native	bit
money	Native	money
smallmoney	Native	smallmoney
float	Native	float
real	Native	real
date	Native	ansidate
datetime	Native	datetime
datetime2	Native	datetime(2)
datetimeoffset	Native	datetimeoffset
smalldatetime	Native	smalldatetime
time	Native	time
char	Native	char
varchar	Native	varchar
text	Native	text (sqlserver)
nchar	Native	nchar
nvarchar	Native	nvarchar
ntext	Native	ntext
binary	Native	binary
varbinary	Native	varbinary
image	Native	image
uniqueidentifier	Native	uniqueidentifier
xml	Native	xml
cursor	Extended	<<cursor>>
hierarchyid	Extended	<<hierarchyid>>
rowversion	Extended	<<rowversion>>
sql_variant	Extended	<<sql_variant>>
spatial geometry types	Extended	<<geometry>>
spatial geography types	Extended	<<geography>>
table	Extended	<<table>>

Azure SQL Database as Target

When Azure SQL Database is used as a target location, following is the mapping of DSS repository data types to the corresponding data type in Azure SQL Database.

Text in green cell indicates the native data type of the DBMS

{% partial file="dss6/advanced-operations/data-type-mapping/azure-sql-database.template.md" /%}