Microsoft SQL Azure extends SQL Server capabilities to the cloud. SQL Azure offers a relational database service called Microsoft SQL Azure Database, and using SQL Azure, you can easily provision and deploy relational database solutions in the cloud — more details at http://www.microsoft.com/windowsazure/sqlazure/
SQL Azure is a cloud database platform where you can host the data for your application on Microsoft’s servers. This allows you to have a scalable highly available database application without the cost of buying this level of database plaform within your own infrastructure.
<b>The differences between SQL Server and SQL Azure are documented at</b>: <a href=”http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=86f12b41-1eba-4567-9ac8-02eaa7d12034″>http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=86f12b41-1eba-4567-9ac8-02eaa7d12034</a>
<i>The paper 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</i>
The <b><a href=”http://sqlazuremw.codeplex.com/”>SQL Azure Migration Wizard</a> </b>helps you migrate your local SQL Server 2005 / 2008 databases into SQL Azure. The wizard walks you through the selection of your SQL objects, creates SQL scripts suitable for SQL Azure, and allows you to migrate your data.
SQL Azure Migration Wizard Requirements
<i>SQLAzureMW requires SQL Server 2008 R2 bits to run</i>.
SQL Azure Migration Wizard Project Details</ul>
<i>The SQL Azure Migration Wizard (SQLAzureMW) gives you the options to analyzes, generates scripts, and migrate data (via BCP) from:
SQL Server to SQL Azure
SQL Azure to SQL Server
SQL Azure to SQL Azure</i>