Need suggestion for moving IoT data storage from local VM to Azure.

Hi!,

Need suggestion for moving IoT data storage from local VM to Azure.

I'm going to revise an existing IOT server application and I need suggestion about data storage strategy.

current situation:

• there is a windows VM machine running WindowsServer2012R2 with a c# .net framework application written by me running as a service.
• This application comunicates with a number of IOT devices (currently 400 devices), collect data from them (in a form of records), and store that data on a MySql server instance running on the same VM.
• For every IOT device there is a dedicated DB on MySql server because every IOT devices has his own data schema.
• Data are not relational, every datarecord has a timestamp and a number of byte/short/float/long/string values (temperature, humidity, flow, ... ...)
• Every device'DB has around 40 tables, and each device generates an average of 5 milions records per year.
• On the same VM there is an instance of MSSQLExpress for system data storage, users list, devices list, ...

Now the system is working but (fortunally..) devices number are growing very fast (by the end of 2024 they should be 2K) and I don't know how long the local instance of MySql is good for that. Moreover databackup and restore from a disaster is another concern.

I'm considering to move the data storage (both IOT devices data and system configuration data) from local VM to Azure.

My question:

Move the local MSSQL to Azure is no problem, I think the proper Azure service is "Fully managed Azure SQL Database" but what about the IoT devices data stored on MySQL ? which is the most suitable Azure service for such a large number of different databases?

thanks fo any suggestion,

regards,

Serafino