Strategy for migrating from Oracle to PG
| От | Johnson, Bruce E - (bjohnson) |
|---|---|
| Тема | Strategy for migrating from Oracle to PG |
| Дата | |
| Msg-id | 638EBF43-5EB2-4D7D-BD00-DF154CC8F3E3@arizona.edu обсуждение исходный текст |
| Ответы |
Re: Strategy for migrating from Oracle to PG
|
| Список | 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
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
В списке pgsql-general по дате отправления: