Striim Migration Service for Google Cloud Documentation

Oracle to Cloud Spanner 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 Oracle sources to a Cloud Spanner target using SMSGC.

  • Oracle Database on-premise

  • Oracle Exadata

  • Amazon RDS for Oracle

SMSGC supports Oracle 11g 11.2.0.4, 12c 12.1.0.2, 12.2.0.1.0, and 18c.

This document assumes the following:

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

  • You have sysdba privileges on the source Oracle Database.

  • You have the privileges required to create tables in the Spanner instance and create a service account in its project.

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. Create tables in the target that are compatible with the source tables to be migrated. These tables should contain no constraints or foreign keys.

  2. In Oracle, enable archivelog and supplemental log data.

  3. Create an Oracle role and user for use by Striim.

  4. Create a service account with the role required to perform inserts, updates, and deletes on the Spanner target tables.

  5. Create an initial load application using Striim's App Wizard.

  6. Test the initial load application with a subset of your source data. If it does not complete successfully, troubleshoot and run it again until it completes successfully.

  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 any problems encountered.

  9. Delete any test data from 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.

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.