- SG: +65 64383504
- IN: 022 25771219
- IN: 022 25792714
- IN: +91 9987536436
This one day training-cum-workshop covers the basics of approaching and handling Oracle Migration Tasks. During the session, our trainer will help you/your team understand how to approach a migration task, how to map the features of Oracle with Postgres and which tools will help complete the migration. This is a hands-on workshop with a real migration scenario which can be demonstrated provided you have an Oracle environment.
Topics covered during the workshop (1 day):
- Introduction to PostgreSQL and concept Mapping
- Identification a candidate and Planning a Migration
- Database Migration
- Post Migration
- EnterpriseDB Postgres Plus Oracle Compatibility Features
- EnterpriseDB Migration Toolkit
- Bulk Loading – COPY and EDB Loader
- Migrating Partitioned and Large Tables
- Migration Workshop
Recommended for: Teams who have organizational goal of large scale migration of multiple Oracle databases to PostgreSQL. Most topics in this workshop would also be applicable for those aiming to migrate from other proprietary databases e.g. Microsoft SQL Server.
Pre-requisites: Prior experience of working with PostgreSQL is preferred and it is highly recommended to take the ‘Foundation of Postgres Administration’ course before attending this workshop. Basic understanding of Relational Database concept will help in overall understanding of concepts and similarities between databases. Familiarity with SQL language is highly recommended. Familiarity with Linux platform and commands will be helpful in better understanding of lab sessions.