Cloud SQL for SQL Server features

This page describes the major features and capabilities of the Cloud SQL for SQL Server beta. Cloud SQL is also available for MySQL and PostgreSQL.

Cloud SQL for SQL Server

Features

  • Fully managed SQL Server databases in the cloud.
  • Custom machine types with up to 416 GB of RAM and 64 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 Platform Console.
  • Instances available in US, EU, or Asia.
  • Customer data encrypted on Google's internal networks and in database tables, temporary files, and backups.
  • Support for secure external connections with the Cloud SQL Proxy or with the SSL/TLS protocol.
  • Import databases using native BAK and SQL files.
  • Export databases using native BAK files.
  • Automated and on-demand backups.
  • Integration with Stackdriver logging and monitoring.

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)
  • AD Authentication
  • 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
  • Always On Availability Groups
  • Database Mail
  • Distribution Transaction Coordinator (MSDTC)
  • File tables
  • FILESTREAM support
  • Maintenance Plans
  • Performance Data Collector
  • Policy-Based Management
  • PolyBase
  • Machine Learning and R Services (requires OS access to install it)
  • Replication
  • Resource Governor
  • SQL Server Audit
  • Server-level triggers
  • Service Broker endpoints
  • T-SQL endpoints (all operations using CREATE ENDPOINT are unavailable)
  • WCF Data Services

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
  • CONTROL_SERVER
  • CREATE DDL EVENT NOTIFICATION
  • CREATE ENDPOINT
  • CREATE TRACE EVENT NOTIFICATION
  • EXTERNAL ACCESS ASSEMBLY
  • RESTORE
  • SHUTDOWN
  • UNSAFE ASSEMBLY

Supported syntax

Cloud SQL for SQL Server supports the Transact-SQL syntax.

Supported languages

You can use Cloud SQL for SQL Server with App Engine applications running in the flexible environment that are written in Java, Python, PHP, Node.js, Go, 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.

Was this page helpful? Let us know how we did:

Send feedback about...

Cloud SQL for SQL Server