Course Outline
Introduction to Database Migration
- Why migrate from proprietary to open source
- Oracle/SQL Server vs PostgreSQL architecture comparison
- Common migration challenges and success factors
- Overview of migration methodologies
Pre-Migration Assessment and Planning
- Database inventory and dependency analysis
- Schema complexity evaluation
- Application compatibility assessment
- Creating a migration roadmap and timeline
Schema Migration Strategies
- Converting Oracle data types to PostgreSQL
- Translating SQL Server data types
- Table structure conversion
- Index and constraint mapping
Object Migration: Stored Procedures and Functions
- PL/SQL to PL/pgSQL conversion
- T-SQL translation techniques
- Built-in function equivalents
- Package and procedure restructuring
Data Migration Tools and Techniques
- Using pg_dump and pg_restore
- Oracle FDW for data migration
- SQL Server integration services
- Handling large data volumes efficiently
Application Code Migration
- JDBC and ODBC driver differences
- Connection string modifications
- SQL dialect differences in application code
- Handling proprietary features
Testing and Validation
- Data integrity verification
- Functional testing strategies
- Performance benchmarking
- Parallel running and cutover planning
Post-Migration Optimisation
- Query performance tuning in PostgreSQL
- Configuration adjustments for migrated workloads
- Monitoring setup and alerting
- Ongoing maintenance considerations
Troubleshooting Common Migration Issues
- Case study: Oracle migration challenges
- Case study: SQL Server migration challenges
- Rollback strategies
- Lessons learned and best practices
Hands-On Migration Workshop
- Guided migration of a sample schema
- Data extraction and loading exercises
- Code conversion practice
- Validation and verification exercises
Requirements
- Basic understanding of relational databases
- Experience with SQL
- Familiarity with database administration concepts
Audience
- Database Administrators
- Application Developers
- IT Architects
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customised Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from £3200 + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
The training instruments provided.
- UNIFI
Course - NoSQL Database with Microsoft Azure Cosmos DB
I found his methods very informative
