Business need
A leading telecom service required the live-migration of its critical 24X7 billing system with near-zero downtime. IT leadership at the company recognized the financial and reputation impact of any downtime. Their responsibility was to identify and execute a migration plan that would eliminate these risks. Due to the high visibility of this project, the company reached out to CimpleSoft based on our experience with zero downtime migrations between database platforms.
Challenge
The company needed to migrate and replicate live data between SQL Server and Oracle with near-zero downtime.
Our solution
CimpleSoft designed a plan based on Oracle GoldenGate 12c to migrate the client’s on-premises SQL Server database to Oracle RAC database hosted in Amazon Web Services (AWS). The plan leveraged best practices and a balanced approach using GoldenGate for both replication and initial load of data resulting in a successful migration to Amazon Web Services (AWS) with minimal business impact.
CimpleSoft provided a balance of duties and having experience with both on-premise SQL Server and Oracle on AWS platform, CimpleSoft provided insight on the design, operation and tuning differences between the two, ensuring optimal performance and ongoing operational excellence. The plan included designing the AWS Oracle server platform, testing the platform with sample data and then establishing the GoldenGate replication between Oracle and SQL Server.
Outcome/Benefits
-
- The production migration was accomplished over a three-month period. This allowed for adequate development and testing of the application prior to entering into production. The cutover to production in Amazon Web Services (AWS) itself was accomplished in less than four hours with no data loss.
- Database performance results: Leveraging the experience of CimpleSoft, the firm was able to successfully execute a near-zero downtime database migration from SQL Server Database on premise to Oracle in AWS.
Technology
Oracle GoldenGate 12c, SQL Server, Oracle RAC, Amazon Web Services (AWS)