#migration

Every time I work on database migrations with GoldenGate, I have the same talks with application teams about missing primary keys. Especially when it comes to LOB replication with GoldenGate. In a

The GoldenGate migration utility provided by Oracle allows you to quickly upgrade your classic architecture into GoldenGate 26ai with Microservices Architecture. But even after some updates, it still

While migrating a GoldenGate classic architecture setup with the migration utility, I recently had the following OGG-12020 error: It is a very cryptic error at first glance, but let's try to

When running the GoldenGate migration utility, which I presented in a previous blog post, you might encounter the following warning on USERID syntax: This is not really a surprise, since USERID is an

Depending on the location of your GoldenGate trail files, you might have to use the convchk utility to relocate them before migrating to the Microservices Architecture. Oracle has the following

With GoldenGate 19c and 21c Premier Support coming to an end in April 2026, time is ticking for many clients with old installations of GoldenGate. Fortunately, Oracle provides a Migration utility

Classic Extracts have been deprecated in GoldenGate 19c and shouldn't be part of your GoldenGate replications for a long time now. Yet, some customers still have them, and with GoldenGate 19c support

At the moment, three versions of GoldenGate are still under Premier Support, but this will very soon change, with GoldenGate 19c and 21c coming out of Premier Support in April this year ! I give

If you've ever had to deal with MongoDB after years (or even decades) of working with SQL, you've probably realized that querying JSON documents can sometimes be painful, to say the least. In

The OGG migration utility helps move an existing GoldenGate Classic Architecture deployment to Microservices when the source database is being migrated. One of the things it handles is migrating