Assessment to do migration of On-premise MySQL to Azure database for MySQL

%3CLINGO-SUB%20id%3D%22lingo-sub-1817850%22%20slang%3D%22en-US%22%3EAssessment%20to%20do%20migration%20of%20On-premise%20MySQL%20to%20Azure%20database%20for%20MySQL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1817850%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20we%20do%20the%20assessment%20to%20do%20migration%20of%20On-premise%20MySQL%20to%20Azure%20database%20for%20MySQL%3F%3C%2FP%3E%3CP%3Eis%20there%20any%20service%20or%20any%20tool%20to%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1818256%22%20slang%3D%22en-US%22%3ERe%3A%20Assessment%20to%20do%20migration%20of%20On-premise%20MySQL%20to%20Azure%20database%20for%20MySQL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1818256%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F845837%22%20target%3D%22_blank%22%3E%40KrunalRaut%3C%2FA%3E%2C%26nbsp%3Bthere%20are%20two%20services%20you%20could%20use%20for%20the%20purpose.%20The%20first%20is%2C%20%22Azure%20Migrate%22%20-%20a%20generic%20one%2C%20and%20it%20supports%20database%20projects%20too.%20The%20second%20is%20Azure%20Database%20Migration%20Service.%20IT%20supports%20all%20kinds%20of%20migrations%2C%20including%20on-prem%20MySQL%20to%20Azure%20managed%20MySQL%20migration.%20One%20of%20the%20caveats%20is%20that%26nbsp%3B%3CSPAN%3EAzure%20managed%20MySQL%20supports%20only%20InnoDB%20tables%2C%20so%20if%20you%20have%20anything%20opposite%20to%20this%20(ISAM)%20you%20gonna%20need%20to%20convert.%20The%20tool%20will%20help%20you%20to%20perform%20the%20assessment%20and%20understand%20the%20migration%20requirements.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EPlease%20also%20read%20carefully%20through%20the%20prerequisites%20section%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdms%2Ftutorial-mysql-azure-mysql-online%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehere%3C%2FA%3E.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

How can we do the assessment to do migration of On-premise MySQL to Azure database for MySQL?

is there any service or any tool to do this?

1 Reply

@KrunalRaut, there are two services you could use for the purpose. The first is, "Azure Migrate" - a generic one, and it supports database projects too. The second is Azure Database Migration Service. IT supports all kinds of migrations, including on-prem MySQL to Azure managed MySQL migration. One of the caveats is that Azure managed MySQL supports only InnoDB tables, so if you have anything opposite to this (ISAM) you gonna need to convert. The tool will help you to perform the assessment and understand the migration requirements.

Please also read carefully through the prerequisites section here.