Re: Strategy for migrating from Oracle to PG

2023-09-05 Thread Deep
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) < john...@pharmacy.arizona.edu> wrote: >

Strategy for migrating from Oracle to PG

2023-09-05 Thread Johnson, Bruce E - (bjohnson)
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 —proje