Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Migration from mysql to Azure mssql

Solved Go to solution
Highlighted

Migration from mysql to Azure mssql

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

Accepted Solutions
Highlighted

Re: Migration from mysql to Azure mssql

Mentor

@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.

View solution in original post

5 REPLIES 5
Highlighted

Re: Migration from mysql to Azure mssql

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

Highlighted

Re: Migration from mysql to Azure mssql

@Geoffrey Shelton Okot

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

Highlighted

Re: Migration from mysql to Azure mssql

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

Highlighted

Re: Migration from mysql to Azure mssql

@Geoffrey Shelton Okot

Thank you for your reply.

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

Highlighted

Re: Migration from mysql to Azure mssql

Mentor

@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.

View solution in original post

Don't have an account?
Coming from Hortonworks? Activate your account here