Thread: Strategy for migrating from Oracle to PG
I have an oracle database with a bunch of schemas that are the data sources for bunch of web applications; what used to be called an ‘intranet’.
I’ve installed pg2sql, and it’s working, and what I want to do is pretty much copy what I existing now as closely as possible.
I've done ora2pg —project_base /oracle_migrate/ —init_project [schema name]
Properly set the schema username and password in the ./config/ora2pg.conf filer each of them
Do I need to create the users in Postgres, or is that done as part of the import_all.sh script?
The schemas themselves are not all that complex, mostly just tables, views and a handful of procedures and grants.
Installed version of Postgres is v15.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
As far as I know, you don't need to create the users, if you create the user anyway before migration then ora2pg will skip the create statement, but objects under the user/schema will be created
On Tue, Sep 5, 2023 at 10:24 AM Johnson, Bruce E - (bjohnson) <Johnson@pharmacy.arizona.edu> wrote:
I have an oracle database with a bunch of schemas that are the data sources for bunch of web applications; what used to be called an ‘intranet’.I’ve installed pg2sql, and it’s working, and what I want to do is pretty much copy what I existing now as closely as possible.I've done ora2pg —project_base /oracle_migrate/ —init_project [schema name]Properly set the schema username and password in the ./config/ora2pg.conf filer each of themDo I need to create the users in Postgres, or is that done as part of the import_all.sh script?The schemas themselves are not all that complex, mostly just tables, views and a handful of procedures and grants.Installed version of Postgres is v15.--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs