Can I replicate data between mySQL and SQL Server/SQL Azure?
- by Ernest Mueller
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:
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.
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."
Go non-realtime and do syncs from mySQL to SQL Azure, which may be somewhat expensive and slower.
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)?
