SQL Azure Federation Data Migration Wizard Released to CodePlex

SQL Azure Federation Data Migration Wizard, one of the most popular tools for migrating your databases to SQL Azure is the SQL Azure Migration Assistant is now availabe for download through CodePlex.What are Federations?"Canonical multi-tier applications application scale-out their front and middle tiers for scalability. With this model, as the demand on the application varies, […]

SQL Azure Federation Data Migration Wizard, one of the most popular tools for migrating your databases to SQL Azure is the SQL Azure Migration Assistant is now availabe for download through CodePlex.

What are Federations?

"Canonical multi-tier applications application scale-out their front and middle tiers for scalability. With this model, as the demand on the application varies, administrators add and remove new instances of the front end and middle tier nodes to handle the workload. With Windows Azure Platform this is easily achieved through easy provisioning of new capacity and the pay as you go model of the cloud. However database tiers have typically not provided support for the same elastic scale-out model. Today, we are working on features that will enable database tiers to scale-out in a similar model in SQL Azure soon. The technology will be available in SQL Azure in the final quarter of calendar year 2011. With federations, database tiers can be scaled-out much like the middle and front tiers of the application elastically based on application workload. With federation applications can expand and contract the number of nodes that service the database workload without downtime," noted Microsoft Wiki.

"Federations are objects in SQL Azure databases just like other objects such as tables and stored procedures but provide system managed databases to allow applications to scale out parts or all of their data. Scaling-out with federations allow building data tier applications with unlimited scalability and best price-performance as well as elasticity and simplified multi-tenancy at the database tier."

You can download SQL Azure Federation Data Migration Wizard from CodePlex.