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
- Reasons for migrating from proprietary systems to open source
- Comparison of Oracle/SQL Server and PostgreSQL architectures
- Common migration challenges and success factors
- Overview of migration methodologies
Pre-Migration Assessment and Planning
- Database inventory and dependency analysis
- Evaluation of schema complexity
- Application compatibility assessment
- Developing 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
- Equivalents for built-in functions
- Restructuring packages and procedures
Data Migration Tools and Techniques
- Utilizing pg_dump and pg_restore
- Oracle FDW for data migration
- SQL Server integration services
- Efficiently handling large data volumes
Application Code Migration
- Differences in JDBC and ODBC drivers
- Modifications to connection strings
- SQL dialect differences within application code
- Managing proprietary features
Testing and Validation
- Verification of data integrity
- Functional testing strategies
- Performance benchmarking
- Parallel running and cutover planning
Post-Migration Optimization
- Query performance tuning in PostgreSQL
- Configuration adjustments for migrated workloads
- Monitoring setup and alerting
- Ongoing maintenance considerations
Troubleshooting Common Migration Issues
- Case study: Challenges in Oracle migration
- Case study: Challenges in SQL Server migration
- 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
14 Hours
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
