Entry situation
Due to the termination of technical support by the manufacturer, the customer decided to update the versions of the databases used. By the way, it was planned to implement new functionalities in the business application and migration to a new hardware platform.
Business Expectations
- Seamless operation of the application on the new version of the database after migration.
- Shortening the migration process (including testing) and eliminating work on weekends.
- Security of migrated business data.
Problem
The business data migration operation was time-consuming (the physical data transfer operation itself took 36h) and required additional time on the part of the business to verify the correctness of the migration. A significant inconvenience was performing work on weekends and stopping service processes. In addition, as the volume of data increased, the time required to complete the entire migration automatically increased.
In case of updating the version of the database environment, additional time was required to test new database functionalities in the business application.
The database change operation was virtually irreversible in the event of problems with a newer version of the database or hardware platform. The client did not have the opportunity to return to the old platform, which posed a significant risk to maintaining the continuity of business processes.
Architecture
- Due to the lower load on the system by business users on weekends, migration operations were performed on non-working days. At that time, the system was unavailable.
- The application used by the customer connected to the Oracle database.
