Postgres to Oracle
From: kyle Hailey <kylelf_at_gmail.com>
Date: Wed, 7 Jun 2023 01:15:44 -0700
Message-ID: <CADsdiQhpx=ULXVtGQhZMBMHmqeoRk8mUqjPsxr4nxGWCDb9++Q_at_mail.gmail.com>
I've heard lots of the years about going Oracle to Postgres, but right now I want to try going from Postgres to Oracle and exploring the best method for testing the current workload on an Oracle test copy. Should I use Kafka to fork the workload, requiring app rearchitecting, or reading logs captured using log_statement='all' to replay on Oracle, or perhaps GoldenGate, which might miss select query workload? What's your preferred method and why?
Kyle
Date: Wed, 7 Jun 2023 01:15:44 -0700
Message-ID: <CADsdiQhpx=ULXVtGQhZMBMHmqeoRk8mUqjPsxr4nxGWCDb9++Q_at_mail.gmail.com>
I've heard lots of the years about going Oracle to Postgres, but right now I want to try going from Postgres to Oracle and exploring the best method for testing the current workload on an Oracle test copy. Should I use Kafka to fork the workload, requiring app rearchitecting, or reading logs captured using log_statement='all' to replay on Oracle, or perhaps GoldenGate, which might miss select query workload? What's your preferred method and why?
Thanks
Kyle
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 07 2023 - 10:15:44 CEST