question

JeremiahJ-5483 avatar image
0 Votes"
JeremiahJ-5483 asked NavtejSaini-MSFT answered

Nightly MySQL Backup to Azure SQL

We have an application using an on-premise MySQL database. We want to upload portions of the MySQL database to Azure on a nightly basis so we have easy access to the data for analytics and reporting purposes, alongside the rest of our data which is stored in Azure SQL databases. On the querying side, we'd like to be working with a consistent syntax, so we'd like to get the MySQL data into an Azure SQL database (as opposed to an Azure MySQL database) like everything else. The on-premise application will continue to use a MySQL database for the time being (switching it over to a SQL Server database is not currently feasible), so any new data generated during the day will be generated within the MySQL database before needing to be converted and uploaded to the Azure SQL database. We need the nightly process to be automated.

I'm looking for guidance on the best way to approach solving this problem.

As I see it, there are two main parts to this process: 1) nightly uploads to the cloud, and 2) an automated MySQL to Azure SQL conversion.

I'm still new to Azure and database programming/administration in general, so I may be coming to this with some inaccurate assumptions or I may be missing some obvious considerations. Any guidance is greatly appreciated.

Thank you,
Jeremiah





azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered

@JeremiahJ-5483

The automated way of doing this can be through Azure Data Factory. This SO link talks about the same.

Once the conversion is done the Azure SQL PaaS service has automated back ups that can be set according to your need.

Please check and get back to us for any questions.

Regards
Navtej S


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@JeremiahJ-5483

Please let us know if you need any further help with this.

Regards
Navtej S

0 Votes 0 ·