Re: Strategy for migrating from Oracle to PG - Mailing list pgsql-general

From Deep
Subject Re: Strategy for migrating from Oracle to PG
Date
Msg-id CAEcc6kQADOx9_8gTeDUE+FgogVXOD4gGWM45vuqzt3PeLLNZ+w@mail.gmail.com
Whole thread Raw
In response to Strategy for migrating from Oracle to PG  ("Johnson, Bruce E - (bjohnson)" <Johnson@pharmacy.arizona.edu>)
List pgsql-general
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 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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: ./configure doesn't make effect?
Next
From: Lorusso Domenico
Date:
Subject: Re: Efficient Partitioning Strategies for PostgreSQL Table with KSUID and High Volume