Striim Migration Service for Google Cloud Documentation

Oracle to Google Cloud PostgreSQL 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 one of the following PostgreSQL targets using SMSGC.

  • sources

    • 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.

  • targets

    • Google Cloud SQL for PostgreSQL

    • PostgreSQL running in a Google Compute Engine virtual machine

    SMSGC supports PostgreSQL versions compatible with PostgreSQL JDBC 4.2 driver version 42.2.2.

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 a user on the target Google Cloud SQL for PostgreSQL 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. 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 PostgreSQL role for use by Striim.

  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. 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.

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.