Wednesday, February 6, 2013

SQL Server vs Azure SQL Database differences

SQL Server Comparison

Focus on logical vs. physical administration
Database and log files automatically placed (no support for Log Shipping, Database Mirroring, etc)
Three high-availability replicas maintained for every database
Tables require a clustered index
Maximum database size is 150 GB (Business edition) 5GB (Web edition)
SQL Server Authentication only

Unsupported SQL Server Features

Use command, distributed transactions, distributed views
Service Broker
Common Language Runtime (CLR)
SQL Agent
Native Encryption
*Backup / Restore

For a more exhaustive list of differences check out this TechNet link (Compare SQL Server with Windows Azure SQL Database)

No comments:

Post a Comment