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