With SQL Data Compare, you can compare and deploy SQL Azure databases.

Data types not supported

SQL Azure databases do not support the following data types:

• Common Language Runtime (CLR) User-Defined Types
• Large User-Defined Types (UDTs)

If you try to deploy an unsupported data type to a SQL Azure database, the deployment script will fail.

T-SQL and SQL Server feature support

SQL Azure has further limitations that can cause SQL Data Compare deployments to fail. For example, SQL Azure does not support Data Compression or SQL Server Replication.

For full details of these limitations, refer to your SQL Azure documentation:

• T-SQL Support (SQL Azure)
• SQL Server Feature Limitations (SQL Azure)