This page describes the major features and capabilities ofCloud SQL for SQL Server. Cloud SQL is also available forMySQL andPostgreSQL.

Note: For information about the supported versions of database engines, seeDatabase versions and version policies.

SQL Server feature support for Cloud SQL

• Fully managed SQL Server databases in the cloud.
• Custom machine types with up to 624 GB of RAM and 96 CPUs.
• Up to 64 TB of storage available, with the ability to automatically increasestorage size as needed.
• Create and manage instances in theGoogle Cloud console.
• Instances available in the Americas, Europe, Asia or Australia. Seealllocations where you can create Cloud SQLinstances.
• Database Migration Service for SQL Server.
• Customer data encrypted on Google's internal networks and in databasetables, temporary files, and backups.
• Column- and cell-level encryption for user databases.
• Support for secure external connections with the Cloud SQL Auth Proxy or with theSSL/TLS protocol.
• Import databases using BAK and SQL files.
• Export databases using BAK files.
• Automated backups, on-demand backups, and point-in-time recovery.
• Instance cloning.
• Integration with Stackdriver logging and monitoring.
• SQL Server Agent enabled to facilitate replication and other jobs.
• Data replication between multiple regions.
• Set a default collation for databases, when creating an instance.
• High availability through a regional persistent disk.
• Integration with customer-managed Active Directory (CMAD), includingWindows Authentication.
• Integration with Managed Service for Microsoft Active Directory, includingWindows Authentication.
• Integration with Microsoft Entra ID.
• Change Data Capture (CDC).
• Intelligent query processing.
• Accelerated database recovery.
• Enhanced data classification.
• UTF-8 character encoding support.
• Enhanced monitoring.
• Dynamic Data Masking (DDM).
• Linked Servers.
• SQL Server Audit.
• SQL Server Publisher.
• SQL Server Subscriber.
• SQL Server Integration Services (SSIS) that runs on a separate host andconnects to Cloud SQL.
• SQL Server Reporting Services (SSRS) that runs on a separate host andconnects to Cloud SQL.
• The bulk copy program (bcp) utility. To learn more about downloading andinstalling the bcp utility,see theMicrosoft documentation.
• BACPAC file imports and exports by using SqlPackage. To learn more about downloading andinstalling SqlPackage,see theMicrosoft documentation.
• Bulk insert for importing data. This feature is supported only on SQL Server 2022.You can use a stored procedure for performing bulk insert.For more information, seeUse bulk insert for importing data.
• Transparent Data Encryption (TDE). For information, seeAbout TDE.
• Always Encrypted without secure enclaves.
• Extended Events (XEvents).
• Custom time zone support at instance creation and post instance creation.
• Temporal tables. For more information, seeTemporal tables.

SQL Server features unavailable for Cloud SQL

The following features are unavailable in Cloud SQL and Google Cloud doesn'tsupport them:

General SQL Server features unavailable for Cloud SQL

• SQL Server Analysis Services (SSAS)
• SP_Configure settings. For more information about this feature, seeConfigure database flags.
• Stretch database
• Backing up to Microsoft Azure Blob Storage
• Buffer pool extension
• The OPENROWSET feature
• Data Quality Services
• Database Log Shipping
• Database Mail
• Distribution Transaction Coordinator (MSDTC)
• File tables
• FILESTREAM support
• Installing a server that requires a full server installation with specificauthentication mechanisms such as Azure DevOps Server.
• Maintenance Plans
• Performance Data Collector
• Policy-Based Management
• PolyBase
• Machine Learning and R Services
• Resource Governor
• Server-level triggers
• Service Broker endpoints
• T-SQL endpoints (all operations usingCREATE ENDPOINT are unavailable)
• WCF Data Services
• Thesysadmin role and system stored procedures that require it
• Hybrid buffer pool
• Memory-optimized tempdb metadata
• In-memory OLTP support for database snapshots
• Registering external languages
• Row-level security
• Object storage backup and restore
• Persistent Memory (PMEM)
• Real-time operational analytics
• Integrated acceleration and offloading
• Hybrid buffer pool with direct write
• Multi-write replication
• Link to Azure SQL Managed instance
• Contained availability group
• Always Encrypted with secure enclaves
• Azure Active Directory authentication
• Support for PFX certificates and other cryptographic improvements
• MS-TDS 8.0 protocol and TLS 1.3

Note: Cloud SQL is a managedservice so it restricts access to certain system procedures and tables thatrequire advanced privileges; you can't create or have access to users withsuperuser permissions.

Other SQL Server operations unavailable for Cloud SQL

• ADMINISTER BULK OPERATIONS
• ALTER ANY CREDENTIAL
• ALTER ANY EVENT NOTIFICATION
• ALTER ANY EVENT SESSION
• ALTER RESOURCES
• ALTER SETTINGS
• AUTHENTICATE SERVER
• CONTROL_SERVER
• CREATE DDL EVENT NOTIFICATION
• CREATE ENDPOINT
• CREATE TRACE EVENT NOTIFICATION
• EXTERNAL ACCESS ASSEMBLY
• RESTORE
• SHUTDOWN
• CLR ASSEMBLIES

Supported syntax for Cloud SQL for SQL Server

Cloud SQL supports theTransact-SQLsyntax.

Supported languages for Cloud SQL for SQL Server

You can use Cloud SQL with App Engine applications running in theflexible environment that are written in:

• C#
• Go
• Java
• Node.js
• PHP
• Python
• Ruby

How you can connect to Cloud SQL for SQL Server instances

You can connect to a Cloud SQL instance from:

• SQL Server Management Studio(SSMS).
  • A client.Learn more.
• The sqlcmdutility.

Connecting to Cloud SQL with Private Google access isn't supported.