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 Azure Data Sync supports a subset of SQL Azure data types.  The first table below lists SQL Azure data types supported by SQL Azure Data Sync. The second table lists the SQL Azure data types currently not supported by SQL Azure 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 Azure 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