Striim Migration Service for Google Cloud Documentation

Perform the initial load

  1. Connect to the Oracle database using sqlplus or another suitable Oracle client.

  2. Enter the following command to get the system change number (SCN) you will provide when starting streaming integration:

    select min(start_scn) from gv$transaction;
  3. If there is any test data in the target tables, use psql or another suitable PostgreSQL client to truncate them.

  4. In SMSGC, open your initial load application in the Flow Designer.

  5. Deploy and start the application.

  6. Monitor application progress to see how the load is progressing. When all data has been loaded, the application status will change from Running to Quiesced. Select Quiesced > Undeploy and your initial load is complete.

Continue with Apply constraints to the target tables.