SQL Azure provides relational database functionality as a utility service. Cloud-based database solutions such as SQL Azure can provide many benefits, including rapid provisioning, cost-effective scalability, high availability, and reduced management overhead.
If you are ready for the cloud — keep in mind this is not an easy question as proved by Netflix cloud migration and Reddit’s experience, going from on-premise SQL Server to SQL Azure doesn’t seem to involve drawbacks.
But what I’m really curious about is how SQL Azure compares to Amazon RDS.
Original title and link: SQL Server and SQL Azure Comparison (NoSQL databases © myNoSQL)