Vielen Dank für die Zusendung Ihrer Anfrage! Eines unserer Teammitglieder wird Sie in Kürze kontaktieren.
Vielen Dank, dass Sie Ihre Buchung abgeschickt haben! Eines unserer Teammitglieder wird Sie in Kürze kontaktieren.
Schulungsübersicht
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
Voraussetzungen
- Basic understanding of relational databases
- Experience with SQL
- Familiarity with database administration concepts
Audience
- Database Administrators
- Application Developers
- IT Architects
14 Stunden
Erfahrungsberichte (2)
Die bereitgestellten Schulungsinstrumente.
- UNIFI
Kurs - NoSQL Database with Microsoft Azure Cosmos DB
Maschinelle Übersetzung
Ich fand seine Methoden sehr informativ
Adnan - Computerbits
Kurs - Oracle SQL Language
Maschinelle Übersetzung
