32.985909
-96.755436
[Video] I am 22 years old, So is SQL server! check out, history of SQL server:
Tag Archives: sqlserver
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:
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 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
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
