• DEPRECATED, NO LONGER USED
• Project Plan
• Planning - phase 1
• Knowledge Transfer
• Overview
• Datamodel Review
• Analysis
• Sample (populated) Database (oracle & postgres)
• Schema
• Views
• Queries
• Stored Procedures
• Identify Risks
• Infrastructure
• Communication
• Source Control
• Packaging Plan
• Technical (migration) Approach
• Assemble Team
• Test Plan
• Functional Test Plan
• Query / Stored Procedure ( Level )
• System ( Level )
• Performance Test Plan
• Test Environment
• Identify Gaps In Automated Testing
• Data Migration Plan
• Oracle -> Postgres
• Postgres -> Oracle
• Schema Upgrade Plan
• Implementation - phase 2
• Git Setup
• Create PG Schema & Sample Database
• Compatibility Libraries
• Back porting
• Packaging
• Development Packages
• Spacewalk Database Infrastructure
• Refine/Tune Postgres Schema
• Tag Queries
• Isolate Development Branch from Master
• Migrate Queries
• Migrate Stored Procedures
• Testing - phase 3
• Functional Regression Test_(Automated Testing)_
• Query/Stored Procedure Performance Testing
• Client driven Performance Testing