Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a replicated mySQL setup running happily on Amazon AWS, making user data available locally in various regions. Now I'm faced with an app that needs to go up on Microsoft Azure and I need to replicate the data over to there as well.

So that's annoying. I am faced with several options:

  1. Replicate from mySQL to SQL Azure/SQL Server seems like it would be lovely - is this possible? I'd consider using a third party tool and paying $$ if I had to. We're not using anything complicated in the db feature set, it's just data in tables.

  2. Get mySQL working on Microsoft Azure - which seems really dicey at best. All the HOWTOs I can find say "this is possible but you really shouldn't try this for production apps."

  3. Go non-realtime and do syncs from mySQL to SQL Azure, which may be somewhat expensive and slower.

  4. Rip out all my mySQL on Amazon and use SQL Server there, which would make Baby Jesus cry.

Has anyone gotten mySQL to SQL Azure/SQL Server replication or syncing working? Or have any other approaches (a NoSQL solution that replicates and might meet our but-we-need-to-join-some-tables needs that can easily be run on Amazon and Azure)?

share|improve this question
    
add comment

2 Answers

I don't know if this will help, but here's a good article on how to use Azure and its SQL Azure from MySQL:

http://whitepages.sfintelligence.com/2011/01/setting-up-wordpress-on-windows-and-sql-azure-a-walkthrough/

Hope that helps!

share|improve this answer
    
Thanks, though the problem is I need to replicate between whatever I'm using on Azure and my mySQL instances on Amazon. So if, as this article talks about, I convert from mySQL to SQL Azure on Azure, I don't have a way to replicate... –  Ernest Mueller Feb 18 '11 at 14:27
add comment

SQL Server Migration Assistant (SSMA) for MySQL lets you quickly convert MySQL database schemas to SQL Server or SQL Azure schemas, upload the resulting schemas into SQL Server or SQL Azure, and migrate data from MySQL to SQL Server or SQL Azure.

You can use this small app and guide on msdn. Get started here : http://msdn.microsoft.com/en-us/library/hh313129%28v=sql.110%29.aspx

It is answered here too : http://stackoverflow.com/questions/16584311/import-mysql-db-into-ms-azure

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.