From: | "Johnson, Bruce E - (bjohnson)" <Johnson(at)pharmacy(dot)arizona(dot)edu> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Strategy for migrating from Oracle to PG |
Date: | 2023-09-01 22:22:51 |
Message-ID: | 638EBF43-5EB2-4D7D-BD00-DF154CC8F3E3@arizona.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | veem v | 2023-09-02 22:35:34 | Question on Partition key |
Previous Message | Adrian Klaver | 2023-09-01 14:42:40 | Re: Taking too much time to fetch the data from Azure postgreSQL Large objects (pg_largeobjects) |