How to setup replication from external on premise sql server to Cloud Sql Server

[Lillian Kwong]

Hello,

I am working on a plan to migrate data from an external on premise sql server 2014 enterprise edition to Google Cloud SQL Server using replication.   Is this possible?

I searched the Google Doc, I only see instructions for MySQL replication but not Sql Server.  Is Sql server replication supported?  If not, is full backup/restore the only option?

Any feedback will be appreciated.

[contreraspinon]

For SQL server 2014, it seems you would have to rely on migrating through a backup and restore. As shown in the documentation, Database Migration Service is not compatible yet with SQL server (a private preview request form is available in that documentation page). In addition, the Cloud SQL current replication documentation for SQL server only supports replicating between Cloud SQL instances. 

You can also follow this guide for migrating your SQL server database which contains a step by step process