| From: | Christophe Pettus <xof(at)thebuild(dot)com> |
|---|---|
| To: | Inzamam Shafiq <inzamam(dot)shafiq(at)hotmail(dot)com> |
| Cc: | "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-24 14:02:14 |
| Message-ID: | C81D5B92-980C-403A-825D-01679837E94A@thebuild.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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.??
To meet all of your requirements, you are almost certainly going to need to look at a commercial solution such as:
* EDB's xDB.
* Oracle's Golden Gate.
* FiveTran's HVR.
We've used xDB successfully in the past for this type of migration.
One open-source change capture tool that you might investigate is:
I personally don't have experience with it, but it might be suitable.
Best,
-- Christophe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ben Chobot | 2023-03-24 14:08:18 | Re: PostgreSQL vs MariaDB |
| Previous Message | Dominique Devienne | 2023-03-24 12:07:20 | Re: Convert pg_constraint.conkey array to same-order array of column names |