One of the great things about SQL Azure is how easy it is to get up and running. If you have SQL Server experience, the process is even smoother. Check out this short 10 minute video where I'll walk you through step-by-step the process to migrate an existing on-premises SQL Server Database to SQL Azure. The migration process in the video that I will go through will be in two parts - 1) migrating the database schema and then, 2) migrating the table data.
By moving your data to SQL Azure, you can free up time and reduce risk associated with managing and maintaining your own SQL Server database servers. Once the SQL Azure database is up and running, you can access it from anywhere on the internet, the data is highly available, scalable and reliable; and very few (if any) code changes will be required for existing client applications - in many cases it's just a matter of changing the connection string to point to the cloud database. Since SQL Azure utilizes SQL Server 2008 technology, the same data access libraries continue to work.
Click here to view the video in full screen mode. You can also download the test database and scripts used in this sample on CodePlex if you want to try this for yourself.
We've got several other tutorials like this one on the SQL Azure Codeplex site. Go to http://sqlazure.codeplex.com to see the entire list. Other walk-throughs and samples there include ones on how to secure a SQL Azure database, programming .NET with SQL Azure, and several others.
If you haven't started experimenting with SQL Azure, for a limited time, new customers to SQL Azure get a 1GB Web Edition Database for no charge and no commitment for 90 days. This is a great way to try SQL Azure and the Windows Azure platform without any of the risk. Check it out here.
Leave comments and let me know how to you enjoyed the content for Migration Week. We want to make sure that you get the maximum experience learning about SQL Azure.