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:
1. BCP
2. SSIS
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
Thank you for information!
Paras doshi what a good site.
There’s a terrific amount of knowledge in this article!
Thanks for the link, it had all the details i was looking for.
Good to know!
Thank you