Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Database Migration
- Why migrate from proprietary to open source
- Oracle/SQL Server vs PostgreSQL architecture comparison
- Common migration challenges and success factors
- Overview of migration methodologies
Pre-Migration Assessment and Planning
- Database inventory and dependency analysis
- Schema complexity evaluation
- Application compatibility assessment
- Creating a migration roadmap and timeline
Schema Migration Strategies
- Converting Oracle data types to PostgreSQL
- Translating SQL Server data types
- Table structure conversion
- Index and constraint mapping
Object Migration: Stored Procedures and Functions
- PL/SQL to PL/pgSQL conversion
- T-SQL translation techniques
- Built-in function equivalents
- Package and procedure restructuring
Data Migration Tools and Techniques
- Using pg_dump and pg_restore
- Oracle FDW for data migration
- SQL Server integration services
- Handling large data volumes efficiently
Application Code Migration
- JDBC and ODBC driver differences
- Connection string modifications
- SQL dialect differences in application code
- Handling proprietary features
Testing and Validation
- Data integrity verification
- Functional testing strategies
- Performance benchmarking
- Parallel running and cutover planning
Post-Migration Optimization
- Query performance tuning in PostgreSQL
- Configuration adjustments for migrated workloads
- Monitoring setup and alerting
- Ongoing maintenance considerations
Troubleshooting Common Migration Issues
- Case study: Oracle migration challenges
- Case study: SQL Server migration challenges
- Rollback strategies
- Lessons learned and best practices
Hands-On Migration Workshop
- Guided migration of a sample schema
- Data extraction and loading exercises
- Code conversion practice
- Validation and verification exercises
Requirements
- Basic understanding of relational databases
- Experience with SQL
- Familiarity with database administration concepts
Audience
- Database Administrators
- Application Developers
- IT Architects
14 Hours
Testimonials (1)
The training instruments provided.
