Striim Migration Service for Google Cloud Documentation

Create and test your streaming integration application

If you used native tools to create the target tables, use SMSGC's App Wizard to create your streaming integration application. Use a template with a CDC source (the templates with Database sources are for initial load). See the PostgreSQL to Google Cloud PostgreSQL Migration Guide for an example.

If you created an initial load application, it is easier to export it to a file, make a few modifications, and import it to create your streaming integration application. See the Oracle to Google Cloud PostgreSQL Migration Guide for an example.

In either case, you will want to verify that the streaming integration application is running correctly by checking that inserts, updates, and deletes on the source are appearing in the target. Then truncate the target tables.