Striim Migration Service for Google Cloud Documentation

Database migration with Striim Migration Service for Google Cloud

SMSGC, as its name indicates, is a tool for database migration. If replication is a better fit for your requirements, use the full Stiim platform, available in the Google Cloud Marketplace,

The steps required to perform migration with SMSGC vary depending on the source and target, but in broad outline, you will likely do the following when the source and target databases are the same (for example, PostgreSQL to Cloud SQL for PostgreSQL):

  1. In the source database, if you have not already done so, enable CDC.

  2. In the source database, create a user for use by SMSGC with the necessary privileges.

  3. In the target database, create a user for use by SMSGC with the necessary privileges.

  4. Copy tables and data from the source to the target using the database's native tools.

  5. Create a streaming integration application using SMSGC's App Wizard.

  6. Test the streaming integration application and troubleshoot as necessary.

  7. Start the streaming integration application.

When the source and target are of different types (for example, on-premise Oracle to Cloud SQL for PostgreSQL), or there are differences between the source and target databases (for example, different table or column names), you will instead fo the following:

  1. In the source database, if you have not already done so, enable CDC.

  2. In the source database, create a user for use by SMSGC with the necessary privileges.

  3. In the target database, create a user for use by SMSGC with the necessary privileges.

  4. Create tables in the target that are compatible with the source tables to be migrated. These tables should contain no constraints or foreign keys until after initial load is completed. When the source and target are the same (for example, on-premise MySQL to Google Cloud SQL for MySQL), you may use native tools that create the target tables and perform the initial load in a single operation.

  5. Create an initial load application using SMSGC's App Wizard. Test it with a subset of your source data and troubleshoot as necessary.

  6. Test the initial load application with a subset of your source data and troubleshoot as necessary.

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

  8. Test the streaming integration application and troubleshoot as necessary.

  9. Truncate the target tables and run the initial load application on your full data set.

  10. Apply constraints and foreign keys to the target tables.

  11. Start the streaming integration application.

These steps are described in detail in the how-to guides for specific source-target combinations (see SMSGC How-To Guides). The rest of this document covers tasks that are the same for all source-target combinations.