Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
See also: Transferring data between SQL Server and MySQL – Chris S Jun 26 '14 at 13:13

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:

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

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 :

It is answered here too :

share|improve this answer

Your Answer


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.