SQL Azure Federation
SQL Azure Federations allows DBAs to scale out their database by federating (sharding) their database. SQL Azure Federation makes it easier to set up the federated databases, and automate the process of adding new federation members.

For more information on SQL Azure Federations see SQL Azure
Microsoft® SQL Azure™ Database is a cloud-based relational database service built on SQL Server® technologies. It provides a highly available, scalable, multi-tenant database service hosted by Microsoft in the cloud. To sign up for SQL Azure, go to SQL Azure Special Offers and Pricing Information.

For a limited time, new customers can sign up for SQL Azure and get a 1GB Web Edition Database for no charge…and no commitment. This is a great way to try SQL Azure – and the Windows Azure platform – without the risk. For more information go to Windows Azure Platform Introductory Special

Windows Azure
Microsoft is offering a Windows Azure 3 month free trial, so you can try Windows Azure and SQL Azure for free.
For more information go to Try Windows Azure 3 Month free trial.

Requirements
SQLAzureFedMW and tools requires SQL Server 2008 R2 bits to run.
SQLAzureFedMW also requires BCP version 10.50.1600.1 or greater

Project Description
SQL Azure Federation Data Migration Wizard simplifies the process of migrating data from a single database to multiple federation members in SQL Azure Federation.

SQL Azure Federation Data Migration Wizard (SQLAzureFedMW) is an open source application that will help you move your data from a SQL database to (1 to many) federation members in SQL Azure Federation. SQLAzureFedMW is a user interactive wizard that walks a person through the data migration process.

The SQLAzureFedMW tool greatly simplifies the data migration process. If you don’t have an SQL Azure account and have been thinking about moving your data to the cloud (SQL Azure), but have been afraid to try because of “unknowns” like cost, compatibility, and unfamiliarity, take advantage of the Try Windows Azure Platform 30 Day Pass.

SQLAzureFedMW Project Details
The SQL Azure Federation Data Migration Wizard (SQLAzureFedMW ) allows you to select a SQL Server database and specify which tables (Data Only) to migrate. The data will be extracted (via BCP) and then uploaded to SQL Azure Federation. The BCP data upload process can be done in a sequential process or parallel process (where you specify the number of parallel threads). See Documentation for more detail.

SQL Azure Migration Wizard Utils (SQLAzureMWUtils)
SQLAzureMWUtils is a class library that a developer can use to assist them in developing for SQL Azure.

Note

SQLAzureFedMW expects that your database schema has already been migrated to SQL Azure Federation and that they tables on the source database match the tables in the federated member databases.

SQLAzureFedMW is built off of the SQLAzureMWUtils library found in the codeplex project SQL Azure Migration Wizard.

Further Reading

OakLeaf Systems: Loading Big Data into Federated SQL Azure Tables with the SQL Azure Federation Data Migration Wizard v1.2 by Roger Jennings.

Microsoft SQL Server Migration Assistant (SSMA): The free Microsoft SQL Server Migration Assistant (SSMA) makes it easy to migrate data from Oracle, Microsoft Access, MySQL, and Sybase to SQL Server. SSMA converts the database objects to SQL Server database objects, loads those objects into SQL Server, migrates data to SQL Server, and then validates the migration of code and data.

For information on SQL Azure and the Windows Azure Platform, please see the following resources:
We welcome your feedback! Please let us know if you like this tool or how we can improve it!

Last edited Mar 3, 2012 at 3:33 AM by ghuey, version 14