Wiki: SQL Azure vs. SQL Server
[This article was contributed by the SQL Azure team.]
This paper in the wiki section of TechNet compares SQL Azure Database with SQL Server in terms of logical administration vs. physical administration, provisioning, Transact-SQL support, data storage, SSIS, along with other features and capabilities.
Read It Here: SQL Azure vs. SQL Server