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
- Rationale for migrating from proprietary systems to open source
- Comparison of Oracle/SQL Server architectures with 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
- Development of a migration roadmap and timeline
Schema Migration Strategies
- Converting Oracle data types to PostgreSQL equivalents
- Translating SQL Server data types
- Conversion of table structures
- Mapping indexes and constraints
Object Migration: Stored Procedures and Functions
- Converting PL/SQL to PL/pgSQL
- Techniques for T-SQL translation
- Identifying equivalent built-in functions
- Restructuring packages and procedures
Data Migration Tools and Techniques
- Utilizing pg_dump and pg_restore
- Leveraging Oracle FDW for data migration
- Using SQL Server Integration Services
- Efficient handling of 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
- Verification of data integrity
- Strategies for functional testing
- Performance benchmarking
- Planning for parallel runs and cutover
Post-Migration Optimization
- Tuning query performance in PostgreSQL
- Adjusting configurations for migrated workloads
- Setting up monitoring and alerting systems
- Considerations for ongoing maintenance
Troubleshooting Common Migration Issues
- Case study: Challenges in Oracle migrations
- Case study: Challenges in SQL Server migrations
- Rollback strategies
- Lessons learned and best practices
Hands-On Migration Workshop
- Guided migration of a sample schema
- Exercises in data extraction and loading
- Practice in code conversion
- Validation and verification exercises
Requirements
- Foundational understanding of relational databases
- Experience with SQL
- Familiarity with database administration concepts
Target Audience
- Database Administrators
- Application Developers
- IT Architects
14 Hours
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
