This is one of 4700 IT projects that we have successfully completed with our customers.How can we support you?
Migrating a Lie Science database into the cloud
Brief description
As part of a planned standard software retirement the customer would like to migrate their application data from an existing Oracle database (on-premise) to a cloud database. The scope of this project is to set up and execute an automated database migration with target system Azure PostgreSQL. In a second phase, changes will made to the business data model and the application data.
Supplement
The integrity of the data is the most important factor in the migration, meaning that thorough testing is crucial. The ora2pg tool provides options to compare the original and the target database schemata. Microsoft also offers a tool (the -Database Compare Utility-) that can be used to verify the results in the target database based on the original. The customer's long-term strategy is to move their historical data into the cloud. For the current use case (storage of application data), we recommend an Azure PostgreSQL instance because it offers low cost and high flexibility.
Subject description
The customer used the database to store development test data generated during the development and approval of biopharmaceuticals. The original application and its datastore (Oracle on-premise) are no longer required, but the data itself is still relevant for legal reasons. After the migration, the customer plans to make technical changes to the data model and the data so that it can be queried effectively as part of an archive search
Overview
- Specialist tasks sample processing
- DV tasks Migration
- System environment Cloud Computing, medium data systems
- Procedure model customer standard
- Databases ora2pg, Oracle Database, PostgreSQL
Project start28.04.2025
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
Service
Industries
© Copyright 2025 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
