Sorry, we only go the other way, supporting migration from certain third-party databases into Oracle.
We have a requirement to migrate few databases from Postgre to Oracle and SQL-SERVER to Oracle.
Non critical databases are planned to move to some other technologies (SQL-Server and Postgres)
Critical Databases are moved to Oracle from SQL-SERVER and Postgres
Please share links or steps to Migrate to Oracle from SQL-SERVER and POSTGRES ..
I am moving to migration ,Patching and Upgade kind of jobs.
I need sound knowledge on these area.
Contact your Oracle Account Manager. Tell them you want to migrate from Postgres to Oracle. We have people here dedicated to help you with that.
We have no one here to help you leave Oracle.
1 person found this helpful
To get started, you can read https://docs.oracle.com/cd/E11882_01/doc.112/e12152/migration.htm#RPTUG40100 or similar in the SQL Developer client's second chapter under Help > SQL Developer Online Help Release 17.4:
2. SQL Developer: Migrating Third-Party Databases
In terms of any required third-part JDBC drivers, Jeff wrote this up a while back....
The supported databases may come and go (Access gone with removal of JDBC ODBC bridge in Java 8, for example, and others added as dictated by strong user demand). As Jeff indicates, best to contact an Oracle Account Manager.
We have gone from Oracle to other databases by reverse engineering from the Oracle database to a Relational Design in SQL Developer Data Modeler (SDDM). Then we forward engineered with a Physical Design for the target database, which has rules for generating DDL suitable for the target. SDDM doesn't generate DDL for everything, but you can do some customization.
As for moving data, we exported to a non-database-specific format, like CSV, then imported. Import was done with a tool for the target database, not with SQL Developer.