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 architecture with PostgreSQL.
- Common migration challenges and key factors for success.
- Overview of various migration methodologies.
Pre-Migration Assessment and Planning
- Conducting database inventory and dependency analysis.
- Evaluating schema complexity.
- Assessing 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.
Migration of Objects: 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 utilities.
- Leveraging Oracle Foreign Data Wrapper (FDW) for migration.
- Employing SQL Server Integration Services.
- Efficently managing large data volumes.
Application Code Migration
- Understanding differences between JDBC and ODBC drivers.
- Modifying connection strings.
- Addressing SQL dialect variations in application code.
- Managing proprietary features.
Testing and Validation
- Verifying data integrity.
- Implementing functional testing strategies.
- Conducting performance benchmarking.
- Planning for parallel running and cutover phases.
Post-Migration Optimization
- Tuning query performance in PostgreSQL.
- Making configuration adjustments for migrated workloads.
- Setting up monitoring and alerting systems.
- Addressing ongoing maintenance considerations.
Troubleshooting Common Migration Issues
- Case study: Challenges encountered in Oracle migrations.
- Case study: Challenges encountered in SQL Server migrations.
- Strategies for rollback procedures.
- Key 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 focused on validation and verification.
Requirements
- Fundamental understanding of relational databases.
- Practical experience with SQL.
- Familiarity with core 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.
