For database solutions, I generally look at SQL/MySQL (transactional) or CosmosDB (schemaless). I use CosmosDB mostly for telemetry data from devices and SQL/MySQL for transactional data that usually originates from web forms or file loads. When I need to load data, I will usually use Azure Batch or HPC (Hi Performance Compute). With SQL managed instances, I can move an existing database to the cloud for legacy databases or I can migrate more modern databases to the cloud. For more on migration planning, go to https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql.
When you work with SQL in Azure, you will create a main central administration point or server, which is a container for single or elastic ...
