| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Oracle to PostgreSQL Migration |
| Date: | 2023-03-20 14:15:25 |
| Message-ID: | CANzqJaCFfaN-mk2q7v7OHiBXFSr4arHeE2Yb+Kg6RrP0uwgmYw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Real-time CDC is the difficult part. ora2pg (using views) can do a static
migration. No coding (unless you consider clever use of bash to modify
config files to be coding). I used it to migrate a 7TB db to Postgresql.
On Mon, Mar 20, 2023 at 8:58 AM Inzamam Shafiq <inzamam(dot)shafiq(at)hotmail(dot)com>
wrote:
> Hi,
>
> Hope everyone is fine.
>
> Can someone help or guide regarding Open Source tools for Oracle to
> PostgreSQL migration with real time CDC. along with this is there any
> possibility to change the structure of the database? Let me explain a
> little more,
>
> We have an Oracle DB which is around 1TB and we want to migrate to
> PostgreSQL that have a new table structure, so we want to perform data
> transformation and real time CDC from Oracle to PostgreSQL. Do we have any
> good open source tool to achieve this with No Coding involved.??
>
> Thanks.
>
> Regards,
>
> *Inzamam Shafiq*
> *Sr. DBA*
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thorsten Glaser | 2023-03-20 14:20:47 | Re: pg_upgrade Only the install user can be defined in the new cluster |
| Previous Message | David G. Johnston | 2023-03-20 14:08:36 | Re: pg_upgrade Only the install user can be defined in the new cluster |