Synchronizing to SQL Azure
Published 19 June 2013
With SQL Compare, you can compare and synchronize 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 synchronize an unsupported object to a SQL Azure database, the synchronization script will fail.
T-SQL and SQL Server feature support
SQL Azure has further limitations that can cause SQL Compare synchronizations 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:
