Tag: SQL Server

GoldenGate Microservices Initial Load Instantiation with WebUI

GoldenGate Microservices Initial Load Instantiation with WebUI

Every GoldenGate configuration requires an initial instantiation of the target database, often referred to as “Initial Load”.  GoldenGate for Oracle is very flexible and allows customers to use different methodology and approaches to instantiate the target database.  The most common approaches are using database-specific tools like Datapump, RMAN, and other file system approaches. GoldenGate however has its own Initial … Continue reading GoldenGate Microservices Initial Load Instantiation with WebUI

No PK with GoldenGate?

No PK with GoldenGate?

When Oracle GoldenGate encounters tables without a primary key (PK) for data replication, it has different approaches depending on the situation: 1. Using Unique Indexes: If a unique index exists on the table, GoldenGate can use those columns to identify rows for updates and deletes. This is the preferred approach as it avoids full table scans on … Continue reading No PK with GoldenGate?