Azure Database for PostgreSQL is previewing a traditional read-only replicas option that can help reduce cost and solve complex BI requirements, although the replicas may experience data lag.

Chart explains the similarities and differences in Azure PostgreSQL deployment options.

Azure Database for PostgreSQL Hyperscale gets a new name and moves to Cosmos DB with minimal impact; however, it lacks Cosmos DB’s data and security sharing advantages.

Illustration shows the timelines for various versions and deployment options supported by Azure Database for PostgreSQL, MySQL, and MariaDB.

PostgreSQL and MySQL, two Azure open-source SQL offerings, increase deployment sizes to meet enterprise needs while Hyperscale moves to Cosmos DB with little notice or change.

SQL Server remains Microsoft’s preferred structured data technology; however, several open-source Azure services now compete with SQL Server, and one is available on-premises.

The chart compares Microsoft’s on-premises and hosted database management offerings, their query languages, and the data types they support.

Sidebar explains the various data types and technologies used in Microsoft database management offerings.

Microsoft's database management landscape includes on-premises and cloud solutions with proprietary and open-source products that are designed for all enterprise data types and workloads.

Sidebar provides a technical discussion of how Azure Arc enabled data services work.