Oracle Streams to GoldenGate Migration

Oracle GoldenGate 12c and Oracle database version 11.2.0.4 and higher support the Streams2OGG utility that converts Streams capture, propagate, and apply processes to GoldenGate equivalents. The utility is available for download on the Oracle Support Portal (https://support.oracle.com). You will need an MOS account to sign in.

At the time of writing, the downloaded zip file: streams2oggv3_0.zip includes the following contents:

  • s2gg_config_check.sql: This is a health check script to assess the Streams environment prior to migration
  • streams2ogg.sql: This is a PL/SQL package that must be compiled in the Streams admin user schema on both source and target databases

The installation script prompts for the GoldenGate ...

Get Oracle GoldenGate 12c Implementer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial