Course Outline
Introduction to Database Migration
- Rationale for migrating from proprietary to open source
- Architectural comparison: Oracle/SQL Server vs. PostgreSQL
- 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
- T-SQL translation techniques
- Identifying equivalent built-in functions
- Restructuring packages and procedures
Data Migration Tools and Techniques
- Utilizing pg_dump and pg_restore
- Employing 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
- Managing proprietary features
Testing and Validation
- Verifying data integrity
- Strategies for functional testing
- Conducting performance benchmarking
- Planning parallel running and cutover procedures
Post-Migration Optimization
- Tuning query performance in PostgreSQL
- Adjusting configurations for migrated workloads
- Setting up monitoring and alerting systems
- Considering ongoing maintenance requirements
Troubleshooting Common Migration Issues
- Case study: Challenges in Oracle migration
- Case study: Challenges in SQL Server migration
- Strategies for rollback
- Key learnings and best practices
Hands-On Migration Workshop
- Guided migration of a sample schema
- Exercises in data extraction and loading
- Practice in code conversion
- Exercises in validation and verification
Requirements
- Fundamental knowledge of relational databases
- Proficiency in SQL
- Understanding of database administration principles
Target 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.
