SolidQ Journal Article : “Migrating Data into Microsoft’s Data Platform – SQL Azure”

Standard

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

0 thoughts on “SolidQ Journal Article : “Migrating Data into Microsoft’s Data Platform – SQL Azure”

What do you think? Leave a comment below.