2 links :
JSONB PostgreSQL: How To Store & Index JSON Data (scalegrid.io)
-
-
Assessment ora2pg
Assessment ora2pg :
ora2pg -t SHOW_REPORT -c ./config/ora2pg.conf --dump_as_html --cost_unit_value 5 --estimate_cost > ./reports/report.html
ora2pg -t SHOW_TABLE -c ./config/ora2pg.conf > ./reports/tables.txt
ora2pg -t SHOW_COLUMN -c ./config/ora2pg.conf > ./reports/columns.txt -
Migration from Oracle Legacy to postgreSQL dMZR
//on the ora2Pg management server :
0- prerequisite
create role role_own_DB login;
1 - export schema
gives the metadata
// on the dMZR jump server (inside ibm cloud)
2 - create the roles in hashicorp vault ( script : new_deploy.sh)
create the roles : dba/own/app
//on the ora2Pg management server :
3 - import schema (script : automation.sh)
import the metadata and upload the data inside the DB postgresql.
4 - backup the postgresql database (pg_dump)
pg_dump --format custom --clean --no-owner --no-privileges apro > bckp_DB.dmp
5 - transfert the backup to dMZR jump server
// on the dMZR jump server
5 - restore only the schema (metadata and data) on ibmclouddb (pg_restore)
pg_restore --role=role_own_DB -n <schemaTOIMPORT> -d ibmclouddb bckp_DB.dmp