Re: migrate off oracle data to postgres

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: migrate off oracle data to postgres
Date: 2020-03-31 14:58:12
Message-ID: 079d990d-b990-e2d4-5b87-6397edb35d36@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-admin pgsql-general

Pepe TD Vo schrieb am 31.03.2020 um 16:15:
> 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?
Not sure what you mean here.

Ora2Pg can migrate the table definitions and copy data as well.

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message JC JC 2020-03-31 15:46:35 Re: migrate off oracle data to postgres
Previous Message Jan Birk 2020-03-31 14:35:27 Re: migrate off oracle data to postgres

Browse pgsql-admin by date

  From Date Subject
Next Message JC JC 2020-03-31 15:46:35 Re: migrate off oracle data to postgres
Previous Message Jan Birk 2020-03-31 14:35:27 Re: migrate off oracle data to postgres

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-03-31 15:30:47 Re: pgAdmin4 installation on macOS installed a User: can I delete it?
Previous Message Jan Birk 2020-03-31 14:35:27 Re: migrate off oracle data to postgres