SQL Azure Data Sync Logo

Each column, local variable, parameter, and expression has a data type.  The data type specifies the kind of data that the column, variable, parameter, or expression can contain.  The data type informs the system how to interpret bit patterns.

SQL Data Sync supports a subset of Windows Azure SQL Database data types.  The first table below lists SQL Database data types supported by SQL Data Sync. The second table lists the SQL Database data types currently not supported by SQL Data Sync.

 Important!
This wiki topic may be obsolete.
This wiki topic is no longer updated by Microsoft. We moved the content to the MSDN Library where we keep it current.
To find the latest version of this topic on MSDN click here.            

Supported Data Types

Data Type Category

Supported SQL Database Data Type

Exact Numbers

Supported:  bigint, bit, decimal, int, money, numeric, smallint, smallmoney, tinyint.

Approximate Numbers

Supported:  float, real.

Date and Time

Supported:  date, datetime2, datetime, datetimeoffset, smalldatetime, time.

Character Strings

Supported: char, varchar, text.

Unicode Character Strings

Supported:  nchar, nvarchar, ntext.

Binary Strings

Supported:  binary, varbinary, image.

Spatial

Supported:  no supported spatial data types

Other Data Types

Supported:  sql_variant, table, uniqueidentifier, xml.

 

Unsupported Data Types

Data Type Category

Unsupported Data Type

Spatial Data Types

Not supported:  geography, geometry.

FileStream

Not supported

CLR UDT

Not supported

SQL UDT

Not supported

XML Data Types

Not supported:  XmlSchemaCollection

Other Data Types

Not supported:  cursor, timestamp, hierarchyid

 For More Information