Saturday, September 18, 2010

Bring your database to the cloud

Thanks to SQL Azure, using SQL server in the cloud isn’t difficult. However if you want to move your existing database to the cloud, there are some things you need to consider. Not all SQL constructs are supported in the Cloud. So how do you know if you can port your database?

I found the following tool on codeplex: SQL Azure Migration Wizard. The SQL Azure Migration Wizard 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. It will also analyze SQL Profiler trace files and TSQL script for compatibility issues with SQL Azure.

No comments: