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
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
Service Broker
Common Language Runtime (CLR)
SQL Agent
Native Encryption
*Backup / Restore
For Data Migration check Migrating Databases to Windows Azure SQL Database
For a more exhaustive list of differences check out this TechNet link (Compare SQL Server with Windows Azure SQL Database) http://social.technet.microsoft.com/wiki/contents/articles/996.compare-sql-server-with-windows-azure-sql-database.aspx
No comments:
Post a Comment