Deploying to SQL Azure
Published 04 June 2013
With SQL Compare, you can compare and deploy SQL Azure databases.
Object types not supported
SQL Azure databases do not support the following object types:
| Application Roles |
| Assemblies |
| Asymmetric Keys |
| Certificates |
| Contracts |
| Defaults |
| Event Notifications |
| Full Text Catalogs |
| Message Types |
| Partition Functions |
| Partition Schemes |
| Queues |
| Application Roles |
| Routes |
| Rules |
| Services |
| Service Bindings |
| Extended Stored Procedures |
| Numbered Stored Procedures |
| Symmetric Keys |
| Remote Synonyms |
| System Tables |
| User-Defined Types |
| XML Schema Collections |
If you try to deploy an unsupported object 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 Compare deployments to fail. For example, SQL Azure does not support Encryption, Data Compression, or SQL Server Replication.
For full details of these limitations, refer to your SQL Azure documentation:
