fr
en
PostgreSQL: migrate from Oracle to PostgreSQL
Database changes need careful preparation without overlooking the applications that depend on them. Understand Oracle changes and their implications for your environment. Develop a framework for evaluating options and organising your technical upgrade.
- Duration
- 1 day 7 hours
- Code
- POS04FR Code
Presentation
Like Oracle, PostgreSQL is an object-relational database management system, but it is free and open-source software. Each has advantages and limitations in functionality and cost, making it valuable to know how to migrate data between them. This course teaches you to compare the two systems and import and export databases from Oracle to PostgreSQL.
Objectives
This course deepens your knowledge of migrating Oracle databases to PostgreSQL.
- Understand the differences between Oracle and PostgreSQL.
- Master import and export methods.
- Understand data type conversions.
- Migrate PL/SQL functions.
- Use ora2pg.
Program
Fundamental differences between Oracle and PostgreSQL engines
- Oracle versus PostgreSQL: features.
- Oracle versus PostgreSQL: data types.
- Oracle versus PostgreSQL: costs.
Master import and export methods
Different ways to transfer data and DDL from Oracle to PostgreSQL.
- Extract DDL.
- The COPY command.
- External tables.
Understand data type conversions
Why do Oracle data types differ from PostgreSQL data types?
- ANSI SQL standards.
- Differences between Oracle and PostgreSQL.
- The specific case of binary objects.
Migrate PL/SQL functions
Once the DDL and data have been migrated, the main task remaining is migrating stored procedures and other functions.
- Overview of Oracle stored procedures and functions.
- Overview of PostgreSQL functions.
- Migrate from Oracle to PostgreSQL: simplified recoding.
The ora2pg tool
Simplify and accelerate Oracle-to-PostgreSQL migrations.
- Concepts.
- Options.
- Installation and use.
Audience
This course is suitable for DBAs familiar with Oracle who have significant experience with the engine, and developers and project managers considering migrating their databases to PostgreSQL.
Prerequisites
Knowledge of PostgreSQL or completion of the PostgreSQL Getting Started and Administration courses is required.
Teaching and assessment methods
- Initial skills assessment
- Training materials provided to participants
- Continuous assessment throughout the course
- End-of-course feedback questionnaire
- Combination of theory and practical application
- Attendance records
- Post-course follow-up evaluation
Dates and sessions
Choose the date and delivery format that suit you.
No upcoming sessions are currently available.