The article titled “Migrating Data into Microsoft’s Data platform – SQL Azure” discusses contemporary tools that are available to migrate SQL server data into Microsoft’s cloud based database i.e SQL Azure. The article is then broadly classified into 1. Schema Migration 2. Data Migration
Following are the tools discussed for Schema Migration:
1. Generate and Publish script wizard (SQL server Management studio)
2. DAC project (Visual studio 2010 Ultimate edition)
Following are the tools discussed (along with best practices) for Data Migration:
Also, Migration process using SQL Azure Migration Wizard is also discussed at the end of the article.
You can read the article here: http://www.solidq.com/sqj/Pages/2011-May-Issue/Migrating-Data-into-Microsofts-Data-Platform-SQL-Azure.aspx