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

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/Tool Generate script wizard SSIS BCP DAC v2.0
Migrate SQL schema YES YES   YES
Migrate Data YES YES YES YES
Migrate large Data   YES YES YES

 

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!

Extending SQL Azure with Azure worker roles << Guest Post on Pinal sir’s blog

My guest post on “Extending SQL Azure with Azure worker role” got published on Pinal sir’s blog. In the article, I discuss three lightweight solutions that augment the contemporary capability of SQL Azure. They are:

1. Automating SQL Azure database backup process

2. Lightweight SQL server agent for SQL Azure

3. Synchronization of databases using SYNC Framework.

To read the article, please visit: http://blog.sqlauthority.com/2011/06/13/sql-server-extending-sql-azure-with-azure-worker-role-guest-post-by-paras-doshi/

Thank you Pinal sir for this wonderful opportunity.

sys.dm_db_partition_stats : A SQL Azure Dynamic management view (DMV) to calculate database size

I have written a blog post on beyondrelational site about a SQL Azure DMV – sys.dm_db_partition_stats that can be used to extract information about database size and size of each individual database object. To read the article please go to: http://beyondrelational.com/blogs/parasdoshi/archive/2011/05/30/sys-dm-db-partition-stats-a-sql-azure-dynamic-management-view-dmv-to-calculate-database-size.aspx

TSQL code to know SQL Azure DB size

A step by step guide to Install Adventure works LT ( sample database ) on SQL Azure

I have written a step by step guide on how to install Adventure works LT DB, a sample database available on codeplex, at my beyondrelational site. here is the link to the article: http://beyondrelational.com/blogs/parasdoshi/archive/2011/05/27/let-s-install-an-adventure-works-lt-database-on-sql-azure.aspx