Google Cloud SQL for SQL Server

Google Cloud SQL for SQL Server is a fully managed cloud-based alternative to relational database service for SQL Server.

Skyvia supports direct connection to Google Cloud SQL for SQL Server.

Your cloud SQL Server instance must be available for external connections.

How to Configure Google Cloud SQL Server Instance for External Connections

  1. Select your SQL Server instance from your Google Cloud SQL dashboard.

    select instance

  2. Click Connections in the left menu and select NETWORKING.

    instance menu

  3. Click ADD A NETWORK and specify the IP addresses from which Skyvia will access your server. Create a separate network for each IP address.

    Skyvia accesses your server from the IP addresses 40.118.246.204, 13.86.253.112, and 52.190.252.0.

    add network

  4. Click Overview in the left menu and find your server’s public IP address.

    Connection Editor window

Creating Connection

Connection Editor window

You need to specify the following parameters for TCP/IP Google Cloud SQL for SQL Server connection:

Server — public IP address of the Google Cloud SQL instance to connect to.

User ID — user name to log in with. You can find the user name by clicking Users in the left menu.

Password — user’s password to log in with.

Database — the name of the cloud database you want to connect to.

The details about additional connection parameters are available in SQL Server or SQL Azure article.

Supported Actions

Skyvia supports all the common actions for Google Cloud SQL for SQL Server.