To meet availability requirements and operational security, all stages of the Oracle databases in the company were migrated to a public cloud. First, the technical planning for the migration of all databases was drawn up, including an inventory of all applications involved. The migration was then prepared using Dataguard and thoroughly checked for functionality and fallback requirements in the lower stages.

At the time of the production migration, all departments were sufficiently prepared and there were no unpleasant surprises. Following the inclusion of all applications and dependencies, a further project to decentralize the database services is to take place in order to transfer the operating costs and operational responsibility further to the individual departments. In further preparation for this project, a script basis was created to enable the administration of database services using Infrastructure as Code (IaC). In future, this should automate the administrative effort for lifecycle measures for “full service” databases on virtual Linux systems and adapt them to the automated management options of the database services provided by the cloud provider.

In order to take advantage of the new cloud infrastructure, internal employees are trained alongside the implementation of scripting and the planning of script behavior.