Client acquired the Company in order to enhance delivery of personalized shopping offers and rewards to consumers in 2012. After the acquisition, the Company technology platform based on PostgreSQL needed to be migrated into an Oracle backend environment as Client’s default database backend. This technology platform had five different PostgreSQL databases powering a comprehensive offer and reward management capabilities.
Client wanted to integrate their platform as fast as possible with minimal changes or disruption to its operating environment that consisted of hundreds of databases. There were significant environmental differences between two sides that required using some clever, out-of-box thinking. Client hired Cloudly in order to solve this problem and directed that we consider using AWS RDS Oracle environment for running a PoC of Client application.
To find best solution approach for migration, Cloudly did an assessment on one postgreSQL databases from Client. Table 01 is represent outcome of initial assessment phase. Based on the complexity of the databases, two major approaches were used for this database migration.