Re: Strategy for migrating from Oracle to PG

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(at)pharmacy(dot)arizona(dot)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
>
>
>