SQL Database Data Types supported by SQL Data Sync (Preview)
Updated: February 12, 2014
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 SQL Database data types. The first table below lists SQL Database data types supported by SQL Data Sync (Preview). The second table lists the SQL Database data types currently not supported by SQL Data Sync (Preview).
The Microsoft Azure SQL Data Sync plug-in on the Microsoft Azure Silverlight portal has been decommissioned. Going forward, use the Microsoft Azure Management portal, for Azure SQL Data Sync.
You access SQL Data Sync (Preview) via the SYNC tab under SQL Database at the Microsoft Azure Management portal. The SYNC tab is only available when you have one or more sync groups. See the topic How To: Create a Sync Group (SDS) for guidance on creating and modifying a sync group from this portal.
See the Navigation section below for links to topics you should read before you start and guidance on creating and modifying sync groups.
Sections in this topic
Table of SQL Database data types supported by SQL Data Sync (Preview) Preview.
Table of SQL Database data types that are not supported by SQL Data Sync (Preview) Preview.
List of column properties that are not supported by SQL Data Sync (Preview) Preview.
Topics you should read before you start and guidance on creating and modifying sync groups.
Supported Data Types
|Data Type Category||Supported SQL Database Data Type|
Supported: bit, decimal, int, numeric, smallint, tinyint.
Supported: float, real.
Date and Time
Supported: date, datetime2, datetime, datetimeoffset, time.
Supported: char, varchar, text.
Unicode Character Strings
Supported: nchar, nvarchar, ntext.
Supported: binary*, varbinary*, image.
Spatial Data Types
Supported: geography, geometry.
Other Data Types
Supported: sql_variant, table, uniqueidentifier, xml.
Unsupported Data Types
|Data Type Category||Unsupported Data Type|
Not supported: money, smallmoney.
Not supported: binary(50), varbinary(5).
Date and Time
Not supported: smalldatetime.
XML Data Types
Not supported: XmlSchemaCollection.
Other Data Types
Not supported: cursor, timestamp, hierarchyid.
Unsupported Column Properties
The following column properties are not supported.
XML SCHEMA COLLECTION
SQL Data Sync (Preview) is a feature of SQL Database. From the Azure Management portal you can perform all tasks necessary to create, deploy, and modify a sync group.
Before you start
Before you begin to design and implement your synchronizations, you should be familiar with these topics.
How to create a sync group
There are six steps to creating a sync group from the Azure Management portal. Details on each step can be found by following these links.
How to modify a sync group
You can modify a sync group’s schema by adding/removing tables or columns in the sync group; or by altering a column’s width or data type. Details can be found by following the links.
ConceptsSQL Data Sync
SQL Data Sync (Preview) Community Resources
Conflict Resolution when Synchronizing
Data Security in SQL Data Sync (Preview)
SQL Data Sync (Preview)Troubleshooting Guide
Glossary of SQL Data Sync Terms
Other ResourcesKnown SQL Data Sync Issues
Azure Management Portal
SQL Azure Data Sync [Channel 9 videos]
SQL Data Sync Forum
Data Types (SQL Azure)
Data Types (Transact-SQL)