SOLVED

Replicate datas from Azure DB for mysql to azure SQL DB

%3CLINGO-SUB%20id%3D%22lingo-sub-390931%22%20slang%3D%22en-US%22%3EReplicate%20datas%20from%20Azure%20DB%20for%20mysql%20to%20azure%20SQL%20DB%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-390931%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20I'm%20happy%20to%20create%20the%20first%20new%20conversation%20there%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20could%20not%20find%20on%20azure%20application%20or%20configuration%20to%26nbsp%3Breplicate%20and%20synchronize%20datas%20from%20Azure%20DB%20for%20mysql%20to%20azure%20SQL%20DB.%20It%20looks%20an%20option%20not%20available%20natively.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20experience%20or%20can%20we%20recommend%20tools%20to%20implement%20this%20synchronization%20on%20azure%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20a%20lot%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-393937%22%20slang%3D%22en-US%22%3ERe%3A%20Replicate%20datas%20from%20Azure%20DB%20for%20mysql%20to%20azure%20SQL%20DB%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393937%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20very%20happy%20you%20choose%20to%20use%20our%20new%20community%20and%20indeed%20you%20are%20the%20first%20one%20to%20ask%20a%20question%20here.%26nbsp%3B%3C%2FP%3E%3CP%3EAbout%20integration%20data%20between%20Azure%20SQL%20DB%20and%20Azure%20Database%20for%20MySQL%20there%20is%20no%20native%20wizard%20to%20set%20replication%20up.%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20the%20way%20to%20go%20here%20is%20to%20use%20either%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fservices%2Fdata-factory%2F%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3EAzure%20Data%20Factory%3C%2FA%3E%20which%20is%20the%20tool%20to%20run%20such%20operation%20or%203rd%20party%20tools%20like%20%3CA%20href%3D%22https%3A%2F%2Fwww.attunity.com%2Fproducts%2Freplicate%2Fattunity-replicate-for-microsoft-migration%2F%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%20target%3D%22_blank%22%3EAttunity%26nbsp%3B%3C%2FA%3Ethat%20have%20a%20specific%20version%20that%20offered%20free%20for%20Microsoft%20customers.%3C%2FP%3E%3CP%3EIn%20any%20case%20the%20replication%20will%20be%20based%20on%20a%20service%20that%20will%20manage%20the%20replication%20on%20top%20of%20the%20databases.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHTH%2C%26nbsp%3B%3C%2FP%3E%3CP%3EYochanan.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi, 

 

First I'm happy to create the first new conversation there :)

 

We could not find on azure application or configuration to replicate and synchronize datas from Azure DB for mysql to azure SQL DB. It looks an option not available natively. 

 

Does anyone have experience or can we recommend tools to implement this synchronization on azure?

 

Thank a lot,

 

Ben

1 Reply
Best Response confirmed by pituach (MVP)
Solution

Hi @BenoitG 

I'm very happy you choose to use our new community and indeed you are the first one to ask a question here. 

About integration data between Azure SQL DB and Azure Database for MySQL there is no native wizard to set replication up. 

However the way to go here is to use either Azure Data Factory which is the tool to run such operation or 3rd party tools like Attunity that have a specific version that offered free for Microsoft customers.

In any case the replication will be based on a service that will manage the replication on top of the databases. 

 

HTH, 

Yochanan.