Cloud SQL for SQL Server
- 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, EU, Asia or Australia. See all locations.
- 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 and on-demand backups.
- 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 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.
SQL Server features unavailable for Cloud SQL
The following features are unavailable in Cloud SQL for SQL Server and not supported by Google Cloud support.
General features unavailable for Cloud SQL
- SQL Server Reporting Services (SSRS), but you can use Compute Engine or a self-managed environment (from which you connect to Cloud SQL)
- SQL Server Analysis Services (SSAS), but you can use Compute Engine or a self-managed environment (from which you connect to Cloud SQL)
- SQL Server Integration Services (SSIS), but you can use Compute Engine or a self-managed environment (from which you connect to Cloud SQL)
- SP_Configure settings (but see Configuring database flags)
- Stretch database
- Backing up to Microsoft Azure Blob Storage
- 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 (requires OS access to install it)
- Resource Governor
- SQL Server Audit
- 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
Other operations unavailable for Cloud SQL
- ADMINISTER BULK OPERATIONS
- ALTER ANY CREDENTIAL
- ALTER ANY EVENT NOTIFICATION
- ALTER ANY EVENT SESSION
- ALTER ANY SERVER AUDIT
- ALTER RESOURCES
- ALTER SETTINGS
- AUTHENTICATE SERVER
- CREATE DDL EVENT NOTIFICATION
- CREATE ENDPOINT
- CREATE TRACE EVENT NOTIFICATION
- EXTERNAL ACCESS ASSEMBLY
- CLR ASSEMBLIES
Cloud SQL for SQL Server supports the Transact-SQL syntax.
You can use Cloud SQL for SQL Server with App Engine applications running in the flexible environment that are written in C#, Go, Java, Node.js, PHP, Python, and Ruby.
How you can connect to Cloud SQL for SQL Server instances
You can connect to a Cloud SQL instance for SQL Server from:
Connecting to Cloud SQL by using Private Google access is not supported.