Azure SQL Database vs Google Cloud SQL

Azure SQL Database is a cloud-native relational database service built on the SQL Server engine and delivered as a fully managed PaaS. Microsoft manages provisioning, patching, backups, monitoring, and high availability. The service supports standard T-SQL and can be accessed through the Azure portal, SQL Server Management Studio, Visual Studio Code's MSSQL extension, and compatible application frameworks. It supports native JSON and REST and GraphQL APIs through Data API builder. Hyperscale independently scales compute and storage and supports scale-out with up to 30 named replicas. For AI application development, it offers native vector search and connections to Azure OpenAI and Azure AI Search. It can connect to Azure Functions and replicate SQL data into Microsoft Fabric for near-real-time querying and analysis. Security and governance include a multilayered approach with Microsoft Defender for SQL; recovery features include disaster recovery and snapshot-based backups. The free offer allows up to 10 General Purpose databases per subscription, each with 100,000 vCore seconds, 32 GB of data, and 32 GB of backup storage monthly. Once limits are reached, a database can auto-pause or remain online with excess use billed at standard rates.

Google Cloud SQL is a managed cloud service for relational databases, supporting MySQL, PostgreSQL, and SQL Server. It provides automated backups, high availability, read replicas, scaling, and point-in-time restoration; retention can extend to 35 days. Database Migration Service can move databases from on-premises systems, Compute Engine, or other clouds, and lift-and-shift migrations to Cloud SQL are available at no additional charge. The service connects with Google Cloud products including Compute Engine, Cloud Run, Google Kubernetes Engine, Cloud IAM, BigQuery, and Datastream, as well as tools such as Looker and Terraform. It encrypts data in transit on Google’s internal networks and at rest, and supports private VPC connectivity and network firewalls. The dedicated trial provides PostgreSQL and MySQL Enterprise Plus instances for 30 days, with no automatic charge, followed by a 90-day stopped state. Cloud SQL is paid, from $0.04; there is no free plan. MySQL use is limited to the InnoDB storage engine.