SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Migrating from SQL Azure to Amazon EC2/RDS


Migrating from SQL Azure to Amazon EC2/RDS

Author
Message
AspNyc
AspNyc
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 239
My employer began using SQL Azure several months ago, but during the past 2-3 months the quality of service has markedly decreased. To date we've experienced at least one system-wide outage (defeats the purpose of a cloud solution to begin with); we've also been struggling for weeks with how to handle with Azure's aggressive connection management behavior. Plus, there's the Azure-enforced T-SQL limitations to deal with: no more SELECT... INTO in stored procedures, unable to change column data types of columns in an existing clustered index without recreating an entire table, etc etc. And while we're not ready to jump ship just yet, I have been asked to investigate alternatives.

An Amazon cloud solution -- some combination of EC2/RDS/EBS/S3 for for web hosting, OLTP and backups -- seems like a pretty good place to start, especially since they offer a free 30-day trial. I've seen plenty of suggestions for migrating from SQL Server to Azure, but not so much on migrating away from SQL Azure and into Amazon RDS. Does anyone have ideas or suggestions on where to look?
Steve Jones
Steve Jones
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: Administrators
Points: 62777 Visits: 19111
Something to think about. The development paradigm in Windows Azure can be different from AWS. In AWS you are essentially renting a VM with SQL Server on it for the database side. All the normal stuff you do from SSMS locally works with AWS, except a few instance level items since you don't have complete control of the instance level stuff. You also don't have Windows Auth working.

The SQL Database in Azure has a different paradigm and may have more/less SQL Server features at any point in time. At some point I think it will be always ahead of the boxed product in all areas, but not right now.

Therefore, if you are using SQL Database and looking to move, you should consider code changes involved.

In moving the data, I suspect SSIS would be one way to do this. I think you can get a bacpac of your schema/data as well, but I'm not sure if that's better or worse. In terms of backups from Azure: http://msdn.microsoft.com/en-us/library/windowsazure/hh335292.aspx

Import side: http://msdn.microsoft.com/en-us/library/hh710052.aspx

My company (Red Gate), makes some tools that might help as well: http://cloudservices.red-gate.com/. Our SQL Compare and Data Compare tools could also work with limited data sets.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search