Table structure changes in GoldenGate environments with different table definitions

In this recipe you will learn how to perform table structure changes in a replication environment where the table structures in the source and target environments are not similar.

Getting ready

For this recipe we will refer to the setup done in Setting up a GoldenGate replication between tables with different structures using defgen in Chapter 2, Setting up GoldenGate Replication. For this recipe we are making the following assumptions:

1. GoldenGate is set up to replicate only DML changes between the source and target environments.

2. The application will be stopped for making schema changes in the source environment.

3. The table structures in the source and target databases are not similar.

4. The GoldenGate Admin user has been granted SELECT ANY TABLE in the source database and INSERT ANY TABLE, DELETE ANY TABLE, UPDATE ANY TABLE, SELECT ANY TABLE in the target database.

5. The definition file was generated for the source...