Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Migration from mysql to Azure mssql

avatar

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.

1 ACCEPTED SOLUTION

avatar
Master Mentor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
5 REPLIES 5

avatar
Master Mentor

@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

avatar

@Geoffrey Shelton Okot

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

avatar
Master Mentor

@Praveen Atmakuri

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

avatar

@Geoffrey Shelton Okot

Thank you for your reply.

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

avatar
Master Mentor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login