Cloud SQL for SQL Server
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 increase storage size as needed.
- Create and manage instances in the Google Cloud console.
- Instances available in the Americas, Europe, Asia or Australia. See all locations where you can create Cloud SQL instances.
- Customer data encrypted on Google's internal networks and in database tables, 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 the SSL/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 Managed Service for Microsoft Active Directory, including Windows Authentication.
- Change Data Capture (CDC).
- Intelligent query processing.
- Accelerated database recovery.
- Enhanced data classification.
- UTF-8 character encoding support.
- Enhanced monitoring.
- Dynamic Data Masking (DDM).
- SQL Server Audit.
- SQL Server Publisher.
- SQL Server Subscriber.
SQL Server features unavailable for Cloud SQL
The following features are unavailable in Cloud SQL and Google Cloud doesn't support them:
General SQL Server features unavailable for Cloud SQL
- SQL Server Reporting Services (SSRS)
- SQL Server Analysis Services (SSAS)
- SQL Server Integration Services (SSIS)
- SP_Configure settings. For more information about this feature, see Configure database flags.
- Stretch database
- Backing up to Microsoft Azure Blob Storage
- BACPAC file imports
- Buffer pool extension
- BULK INSERT and OPENROWSET (BULK...) features
- The OPENROWSET feature
- Data Quality Services
- Database Log Shipping
- Database Mail
- Distribution Transaction Coordinator (MSDTC)
- File tables
- FILESTREAM support
- Maintenance Plans
- Performance Data Collector
- Policy-Based Management
- Machine Learning and R Services
- Resource Governor
- Server-level triggers
- Service Broker endpoints
- T-SQL endpoints (all operations using
CREATE ENDPOINTare unavailable)
- WCF Data Services
sysadminrole and system stored procedures that require it
- Linked Servers
- Hybrid buffer pool
- Memory-optimized tempdb metadata
- In-Memory OLTP support for database snapshots
- Registering external languages
- Row-level security
- Transparent Data Encryption (TDE). For information about encryption on Google Cloud, see About customer-managed encryption keys (CMEK) and Default encryption at rest.
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
- CREATE DDL EVENT NOTIFICATION
- CREATE ENDPOINT
- CREATE TRACE EVENT NOTIFICATION
- EXTERNAL ACCESS ASSEMBLY
- CLR ASSEMBLIES
Supported syntax for Cloud SQL for SQL Server
Cloud SQL supports the Transact-SQL syntax.
Supported languages for Cloud SQL for SQL Server
You can use Cloud SQL with App Engine applications running in the flexible environment that are written in:
How you can connect to Cloud SQL for SQL Server instances
You can connect to a Cloud SQL instance from:
Connecting to Cloud SQL with Private Google access isn't supported.