SQL Azure

A 2-post collection

Exposing your data using .NET WCF Data Services: Part 2

In the previous post Exposing your data using .NET WCF Data Services: Part 1, I wrote about creating a WCF Data Services application to expose data from a SQL Database. In this post we’ll go through publishing the database created in Part 1 to the Windows Azure cloud. Creating the Windows Azure database The first step in migrating the Quotes data services application that we created in Part 1 is to move our database into the cloud. To get started with this the initial step is to create a new database instance in Azure, which we can do in the management portal by the following steps. Navigate to the SQL Databases node Once we are logged into the Azure...

Migrating a SQL database to SQL Azure

Happy New Year 2011 to you all. Continuing on with my previous posts on Windows Azure I thought I?d write up a post covering migrating a SQL Server database from a local SQL Server and into the cloud. The conversion of a SQL Server database into SQL Azure for publishing in the cloud can be done by the SQL Azure Migration Wizard which you can find on CodePlex. For the purpose of this post I have decided to try and Migrate the AdventureWorks sample database into SQL Azure format. Once you?ve installed the AdventureWorks databases from the link above when you logon to your local instance of SQL Server you should see the following databases listed. Now your...