Summary – SQL server to SQL Azure migration << Paras Doshi

Standard
In this blog post, I aim to summarize database migration options that I have been blogging about for past few weeks. Choosing right tool is a key decision when you decide to migrate SQL server to SQL Azure – And I hope this blog post can help you decide which is the best tool to be picked for your scenario:
 
Here is the summary:
 
Scenario/ToolGenerate script wizard SSISBCPDAC v2.0
Migrate SQL schemaYESYES YES
Migrate DataYESYESYESYES
Migrate large Data YESYESYES

 

Blog Posts featuring tools that help migrate SQL server database to SQL Azure:

BCP:

Migrating SQL server Data to SQL Azure using BCP << Paras Doshi

SSIS:

How to use SQL server Integration services (SSIS) to migrate data from SQL server to SQL Azure << Paras Doshi

Generate script wizard:

How to use Generate script wizard to migrate SQL server Database to SQL Azure << Paras Doshi

Dac’s v2.0 (SQL Azure Import Export CTP):

[ SQL Azure Labs ] Exploring SQL Azure Import/Export Feature (CTP)

 

Related posts:

Migrating TSQL file and SQL server 2005 / 2008 Database to SQL Azure using SQL Azure Migration wizard << Paras Doshi

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

 

CrossPosted From: Summary – SQL server to SQL Azure migration << Paras Doshi

 

Can you please consider posting your valuable feedback/comments/suggestion in comments section? Thanks!

0 thoughts on “Summary – SQL server to SQL Azure migration << Paras Doshi

What do you think? Leave a comment below.