|Scenario/Tool||Generate script wizard||SSIS||BCP||DAC v2.0|
|Migrate SQL schema||YES||YES||YES|
|Migrate large Data||YES||YES||YES|
Blog Posts featuring tools that help migrate SQL server database to SQL Azure:
Generate script wizard:
Dac’s v2.0 (SQL Azure Import Export CTP):
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!
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.
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
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