OLTP in Azure
There are several Azure services that support OLTP applications, covering relational as well as non-relational data:
- Azure SQL Database
- Azure SQL Managed Instance
- Azure Cosmos DB
- Azure Database for PostgreSQL
- Azure Database for MySQL
Azure SQL Database
Azure SQL Database provides a relational database engine hosted as PaaS. Customers can provision this service, bring their own database schema and data, and connect their applications to it. Azure SQL Database provides many of the features of SQL Server when deployed on a virtual machine. These services do not provide a user interface to create tables and schemas, nor do they provide any querying capabilities directly via the portal. SQL Server Management Studio, Azure Data Studio, or the SQL CLI and command-line tools should be used to connect to these services and directly work with them.
Azure SQL Database comes with three distinct deployment models:
- Single instance: In this...