SQL Compare 10

Deploying to SQL Azure

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:


Didn't find what you were looking for?