Course Outline
Introduction to Database Migration
- Reasons for migrating from proprietary to open source
- Comparison of Oracle/SQL Server versus PostgreSQL architecture
- Common migration challenges and key success factors
- Overview of migration methodologies
Pre-Migration Assessment and Planning
- Database inventory and dependency analysis
- Evaluation of schema complexity
- Assessment of application compatibility
- Developing a migration roadmap and timeline
Schema Migration Strategies
- Converting Oracle data types to PostgreSQL
- Translating SQL Server data types
- Converting table structures
- Mapping indexes and constraints
Object Migration: Stored Procedures and Functions
- Converting PL/SQL to PL/pgSQL
- Techniques for T-SQL translation
- Equivalent built-in functions
- Restructuring packages and procedures
Data Migration Tools and Techniques
- Utilizing pg_dump and pg_restore
- Using Oracle FDW for data migration
- Leveraging SQL Server integration services
- Efficiently managing large data volumes
Application Code Migration
- Differences between JDBC and ODBC drivers
- Modifying connection strings
- Addressing SQL dialect differences in application code
- Dealing with proprietary features
Testing and Validation
- Verifying data integrity
- Strategies for functional testing
- Performance benchmarking
- Planning for parallel running and cutover
Post-Migration Optimization
- Tuning query performance in PostgreSQL
- Adjusting configurations for migrated workloads
- Setting up monitoring and alerting
- Considerations for ongoing maintenance
Troubleshooting Common Migration Issues
- Case study: Challenges in Oracle migration
- Case study: Challenges in SQL Server migration
- Rollback strategies
- Lessons learned and best practices
Hands-On Migration Workshop
- Guided migration of a sample schema
- Exercises on data extraction and loading
- Practice in code conversion
- Exercises for validation and verification
Requirements
- Fundamental understanding of relational databases
- Experience working with SQL
- Familiarity with database administration concepts
Audience
- Database Administrators
- Application Developers
- IT Architects
Testimonials (3)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
- UNIFI
Course - NoSQL Database with Microsoft Azure Cosmos DB
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
