Re: migrate off oracle data to postgres

From: Jan Birk <jan(dot)g(dot)birk(at)gmail(dot)com>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: migrate off oracle data to postgres
Date: 2020-03-31 14:35:27
Message-ID: 98efff404a8130d7ae0aa15c435cf80937c6784e.camel@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-admin pgsql-general

tir, 31 03 2020 kl. 14:15 +0000, skrev Pepe TD Vo:
> I have a huge data on Oracle, would you please suggest how to migrate all data
> off Oracle to Postgres? Do I need to export into csv and upload to postgres?
> Ora2pg is limited data from oracle to postgresql right?

How huge is huge?
We have used ora2pg for ~1tb with success

Best

/Jan

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Thomas Kellerer 2020-03-31 14:58:12 Re: migrate off oracle data to postgres
Previous Message John Wiencek 2020-03-31 14:20:22 Re: migrate off oracle data to postgres

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Kellerer 2020-03-31 14:58:12 Re: migrate off oracle data to postgres
Previous Message John Wiencek 2020-03-31 14:20:22 Re: migrate off oracle data to postgres

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2020-03-31 14:58:12 Re: migrate off oracle data to postgres
Previous Message John Wiencek 2020-03-31 14:20:22 Re: migrate off oracle data to postgres