Bedankt voor uw aanvraag! Een van onze medewerkers neemt binnenkort contact met u op
Bedankt voor uw boeking! Een van onze medewerkers neemt binnenkort contact met u op.
Cursusaanbod
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 Optimization
- 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
Vereisten
- Basic understanding of relational databases
- Experience with SQL
- Familiarity with database administration concepts
Audience
- Database Administrators
- Application Developers
- IT Architects
14 Uren
Getuigenissen (2)
De opleidingsinstrumenten die worden geleverd.
- UNIFI
Cursus - NoSQL Database with Microsoft Azure Cosmos DB
Automatisch vertaald
Ik vond zijn methoden zeer informatief
Adnan - Computerbits
Cursus - Oracle SQL Language
Automatisch vertaald
