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 30 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).
SQL Server features unavailable for Cloud SQL
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
- 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
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.