Migration from mysql to Azure mssql

[#1]

I would like to migrate the mysql database from HDP cluster to Azure mssql database

what is advantages and disadvantages for this activity

If it is advantage, how i have to migrate ..kindly provide the process

What about existing data, how to migrate the existing data to azure mssql.

[#2]

@Praveen Atmakuri

There is a better option almost out-of-the-box if you want to preserve your MySQL and avoid migration downtime

What is Azure Database for MySQL?

Hope that helps

[#3]

@Geoffrey Shelton Okot

what about existing data and how do i access the existing data ?

[#4]

@Praveen Atmakuri

For the existing, you can accomplish this using the mysqldump to backup and then load the data to the Azure Mysql DB

[#5]

@Geoffrey Shelton Okot

Thank you for your reply.

what is fundamental difference between Azure MSSQL and Azure Mysql DB?

[#6 · Accepted solution]

@Praveen Atmakuri

I want to ensure the document in the link above will move your on-premise MySQL to MySQL in Azure.Azure Database for MySQL is a Microsoft cloud based service based on the MySQL Community Edition database engine.

Advantages

• Built-in high availability with no additional cost.
• Predictable performance, using inclusive pay-as-you-go pricing.
• Scale as needed within seconds.
• Secured to protect sensitive data-at-rest and in motion.
• Automatic backups and point-in-time-restore for up to 35 days.
• Enterprise-grade security and compliance.

Difference between Azure MSSQL and Azure MySQL DB

• MySQL is open source while MSSQL is licensed(commercial).
• MySQL supports more programming languages than MSSQL MySQL supported several Platforms Windows, Linux and Mac OS while MSSQL runs exclusively on windows though Microsoft recently announced MSSQLwill be available on Linux.
• MySQL supports a number of storage engines. While using MySQL even have option to use a plug-in storage engine.
• MySQL does not allow users to kill or cancel a query when it is running But SQL Server programmers can truncate a database query during execution without killing the entire process.
  

These are just but a few distinct differences between the 2 RDBMS's

If you found this answer addressed your question, please take a moment to log in and click the "accept" link on the answer.