Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: Avinash Kumar <avinash(dot)vallarapu(at)gmail(dot)com>, Pepe TD Vo <pepevo(at)yahoo(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org, Thomas Kellerer <shammat(at)gmx(dot)net>
Subject: Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL
Date: 2020-04-20 15:30:54
Message-ID: DB18F73F-E635-41C0-A22B-EF21E00B5919@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

So, the big question is: how much downtime can you afford on the current Oracle DB?

Yes, you should investigate the most efficient way to transfer data, but with TBs it will still be significant time. If you can afford the down time, great--kill all other connections to Oracle and go for it. If not, that's more complicated since you'll have to figure out a way to track and apply changes that happen during the copy...

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Avinash Kumar 2020-04-20 15:38:45 Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL
Previous Message Avinash Kumar 2020-04-20 15:26:14 Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL