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 solutions to open source.
- Comparison of Oracle/SQL Server architecture 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.
- Developing a migration roadmap and timeline.
Schema Migration Strategies
- Converting Oracle data types to PostgreSQL equivalents.
- 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 translating T-SQL.
- 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.
- Economically 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.
- Performance benchmarking.
- Planning parallel running and cutover procedures.
Post-Migration Optimization
- Tuning query performance in PostgreSQL.
- Making configuration adjustments for migrated workloads.
- Setting up monitoring and alerting systems.
- Considerations for ongoing maintenance.
Troubleshooting Common Migration Issues
- Case study: Challenges in Oracle migration.
- Case study: Challenges in SQL Server migration.
- Strategies for rollback.
- 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.
- 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.
14 Hours
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
