Manage Schema Evolution

Managing schemas requires tracking and synchronizing structural changes such as tables, columns, indexes, and data types between source and target systems. An effective schema management technique ensures that replication continues smoothly when applications evolve or database changes are deployed. It also helps prevent failures caused by mismatched structures, unsupported data types, or missing objects.

Oracle GoldenGate provides techniques to manage schemas for homogeneous or like to like data replication and heterogeneous or cross-platform replication. For homegeneous replication, administrators can use the existing DDL Replication functionality, which is available with Oracle to Oracle and MySQL to MySQL databases.