Search Postgresql Archives

Strategy for migrating from Oracle to PG

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux