Modernize any database in the cloud
Modernizing your databases can improve how you store, process, and feed data. The goal of database transformation is to improve the reliability, performance, and cost of your data. Adopt platform-as-a service (PaaS) and infrastructure-as-a-service (IaaS) solutions to modernize any database in the cloud.
Two categories of database solutions:
We have two categories of database solutions. These two categories allow you to modernize any type of database in the cloud.
- "Azure SQL" is a category of database solutions for SQL Server and other closed-source SQL databases.
- "Open-source and NoSQL" is a category of database solutions for open-source SQL databases and NoSQL databases.
PaaS and IaaS solutions:
There are two PaaS and one IaaS solution to choose from in each database category. Each option provides a different balance of control and productivity. We include infrastructure-as-a-service (IaaS) solutions to accommodate the different database origins customers start with.
Azure SQL:
- SQL Server on virtual machines (IaaS)
- Azure SQL Managed Instance (PaaS)
- Fully managed Azure SQL database (PaaS)
Open-source SQL & NoSQL:
- MySQL, MariaDB, or PostgreSQL on virtual machines (IaaS)
- Azure Cosmos DB and Azure Managed Instance for Apache Casandra (PaaS)
- Fully managed MySQL, MariaDB, and PostgreSQL databases (PaaS)
Use the tables below to find implementation guidance on modernizing your database.
Option 1 - Modernize your SQL Server and other SQL databases
Modernize your SQL Server and other SQL databases. Azure SQL supports SQL Server and other proprietary SQL databases like Oracle and Db2.
Finding the right balance of control and productivity is a main consideration in database modernization. Use the following table to find the right balance. Check to see if the solution listed meets your needs.
When you find the right solution, follow the implementation guidance to modernize your application.
| Control vs. Productivity | Solution | Your needs | Implementation guidance |
|---|---|---|---|
| Most control | SQL Server on Windows or Linux virtual machines (VMs) |
|
Database origin: SQL Server Oracle Db2 Azure Database Migration Service |
| Balance control & productivity |
Azure SQL Managed Instance |
|
Database origin: SQL Server Oracle Db2 |
| Most productivity | Azure SQL Database |
|
Database origin: SQL Server Oracle Db2 Access SAP ASE |
Option 2 - Modernize your open-source SQL & NoSQL databases
Modernize your open-source SQL databases and NoSQL databases. Finding the right balance of control and productivity is a main consideration in database modernization. Use the table to find the right balance. Check to see if the solution listed meets your needs.
When you find the right solution, follow the implementation guidance to modernize your application.
| Control vs. Productivity | Solution | Your needs | Implementation guidance |
|---|---|---|---|
| Most control | Open-source databases on virtual machines - MySQL, MariaDB, PostgreSQL |
|
Using the Azure Database Migration Service Installing a database on a VM |
| Balance control & productivity | Azure Managed Instance for Apache Cassandra |
|
Apache Cassandra |
| Most productivity | Azure Cosmos DB |
|
Azure Cosmos DB |
| Most productivity | Azure Database for MySQL |
|
Azure Database for MySQL Using the Azure Database Migration Service |
| Most productivity | Azure Database for MariaDB |
|
Azure Database for MariaDB |
| Most productivity | Azure Database for PostgreSQL |
|
Azure Database for PostreSQL |
Next steps
Get more guidance with the Azure Migration and Modernization Program