Converting a large SQL Server Database to Azure Storage

Posted by Laith on Stack Overflow See other posts from Stack Overflow or by Laith
Published on 2010-02-02T15:24:54Z Indexed on 2010/03/17 14:31 UTC
Read the original article Hit count: 431

Filed under:

sqlazure

|

azure-storage-tables

Hi guys,

I have a very large database structure, (Data is not important at this point, I can migrate the info in the db pretty easily if the structure is done) , all reside in SQL Server and I even published it to SQL Azure, but thinking about the limitation of SQL Azure in size, made me decide to switch most of the tables that do not need all the bells and whistles of SQL Azure to Azure Table and blob storage.

I was thinking of creating a TT template that dose that, but was wondering if their is a tool that do that.

Any ideas or thoughts.

The only tables that i would keep in SQL Azure would anything related to transactions like payments.

Appreciate your thoughts and advice

© Stack Overflow or respective owner

Related posts about sqlazure

Migrating Databases from SQL Server 2008 to SqlAzure

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Connect SQL Azure through SSMS. (It will get connected, only if you have port 1433 open.) Create required databases on SQL Azure. Create and execute schema scripts for databases.(Make sure you have written scripts which are 100% compatible with SQL Azure. Tool called SQL Azure migration… >>> More
Azure - Unable To Get SQL Azure Invitation Code!

as seen on Stack Overflow - Search for 'Stack Overflow'
Scenario I'm trying to convert my Silverlight Business Application over to the cloud with the help of Azure. I have been following this link from Brad Abrams blog. Both the links to Windows Azure and SQL Azure crash out in Google Chrome, they work in Internet Explorer, but it's literally one of… >>> More
Which ORM to use with SQL Azure?

as seen on Stack Overflow - Search for 'Stack Overflow'
Just wondering what everyones thoughts on what ORM to use for SQL Azure? I'm fairly comfortable using LINQ-to-SQL and I believe it is possible to get it working with SQL Azure. However, from my understanding (correct me if I'm wrong), no further improvements will be made to Linq-to-SQL in future… >>> More
TransactionScope() in Sql Azure

as seen on Stack Overflow - Search for 'Stack Overflow'
Does Sql Azure support using TransactionScope() when performing inserts? Below is a code snippet of what I am trying to do. using (var tx = new TransactionScope(TransactionScopeOption.RequiresNew, new TransactionOptions() { IsolationLevel = IsolationLevel.ReadCommitted })) { … >>> More
Does SQL Azure Support Relational Databases?

as seen on Stack Overflow - Search for 'Stack Overflow'
I keep reading that SQL Azure doesn't support relational databases; however, I just tapped into my SQL Azure Database and scripted a relational database. I even checked to see what was present using: select * from sys.objects Any thoughts? >>> More

Related posts about azure-storage-tables

Tools for viewing and managing Azure storage tables and queues

as seen on Stack Overflow - Search for 'Stack Overflow'
What tools are available for viewing and managing Azure storage tables and queues - and which do you recommend? >>> More
Azure table storage: DataServiceClientException - "The condition specified using HTTP conditional he

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, we have just deployed an Azure App and are getting these errors when updating an object in TableStorage? Any ideas? Thank you! >>> More
"One of the request inputs not valid" error when attempting to update Azure Table Storage

as seen on Stack Overflow - Search for 'Stack Overflow'
I am attempting to update an entry in Azure Table Storage. The function is: public void SaveBug(DaBug bug) { bug.PartitionKey = "bugs"; bug.Timestamp = DateTime.UtcNow; if (bug.RowKey == null || bug.RowKey == string.Empty) { … >>> More
Azure Tables or SQL Azure?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am at the planning stage of a web application that will be hosted in Azure with ASP.NET for the web site and Silverlight within the site for a rich user experience. Should I use Azure Tables or SQL Azure for storing my application data? >>> More
Converting a large SQL Server Database to Azure Storage

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi guys, I have a very large database structure, (Data is not important at this point, I can migrate the info in the db pretty easily if the structure is done) , all reside in SQL Server and I even published it to SQL Azure, but thinking about the limitation of SQL Azure in size, made me decide to… >>> More