Our Client is the world’s leading provider of software and services higher education institutions need to help students succeed. We help more than 2,500 institutions and 18 million students worldwide with our technology designed specifically for higher education, cloud-based solutions, and professional services. Our Client provides student information systems (SIS), finance and HR, recruiting, retention, analytics and advancement software solutions. With more than 1,400 institutions subscribing to Our client’s cloud services and SaaS offerings, we are one of the largest providers of cloud-based solutions.
Our Client wanted to run a research project to build a multi-backend platform for their educational applications starting with their existing Oracle-based applications as they started cloud-based, online offerings. This meant two important constraints of their requirements.
- Compatible database schemas and packages between different databases like Oracle and PostgreSQL, needed from current Oracle schemas and packages with:
- Minimal application changes
- Minimal data migrations from legacy / Oracle
- Minimal manual interventions for maintaining bidirectional compatibility while changes may originate from any of the supported databases
To find best solution approach for migration, Cloudly did an assessment on five different Oracle databases from Client. Table 01 is represent outcome of initial assessment phase. Based on the complexity of the databases below are the four major approaches selected for database migration.