Striim Migration Service for Google Cloud Documentation

SQL Server to Google Cloud SQL Server Migration Guide

For an overview and conceptual discussion of SMSGC, see Striim Migration Service User Guide.

This document provides detailed instructions for migrating data from one of the following SQL Server sources to one of the following SQL Server targets using SMSGC.

Sources

  • SQL Server version 2008, 2012, 2014, 2016, or 2017 on-premise

  • Amazon RDS for SQL Server Developer, Standard, or Enterprise version 2012, 2014, 2016, or 2017 (SMSGC does not support Express since it does not support change data capture)

  • Azure SQL Database Managed Instance (SMSGC does not support Azure SQL Database single databases or elastic pools since they do not support change data capture)

Targets

  • Google Cloud SQL for SQL Server

  • SQL Server 2008, 2012, 2014, 2016, or 2017 running in a Google Compute Engine virtual machine

This document assumes the following:

  • You have completed the tasks described in Deploy SMSGC and Connect SMSGC with your private network.

  • You have the access and privileges required to enable change data capture and create a user in the source SQL Server instance.

  • You have the privileges required to create a user on the target Google Cloud SQL for SQL Server instance.

To create the SMSGC application, you will perform the following tasks, as detailed in this document. It is important that you perform the steps in the order in which they are described here.

  1. In the source SQL Server instance, enable change data capture and create a user for SMSGC.

  2. In the target SQL Server instance, create a user for SMSGC.

  3. Copy the tables and data from the source to the target using the native tools of SQL Server and Google Cloud SQL for SQL Server. Alternatively, create tables in the target and create an initial load application to populate them as discussed in Create and test the initial load application.

  4. Create a streaming integration application by exporting TQL code for the initial load application, making a few revisions, and importing it.

  5. Test the streaming integration application and troubleshoot any problems encountered.

  6. Start the streaming integration application.

We strongly recommend you read both the Striim Migration Service User Guide and this entire document before starting to follow any of the detailed instructions below.