This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4843 IT projects that we have successfully completed with our customers.How can we support you?
Migration of an On-Premise Database to the Azure Cloud
Project duration: 6 months
Brief description
To reduce maintenance costs, the customer migrates the database for individual software from an on-premise Oracle instance to an Azure SQL database in the Azure cloud.
Supplement
A special challenge is that the software uses proprietary functions for database access. In the course of the migration, the data access is newly implemented with the help of a standard OR mapper library. All SQL statements must be analyzed and mapped to corresponding methods of the OR-Mapper library. Furthermore, the user authentication of database logins is converted to Azure Active Directory,
Subject description
PTA migrates the database and adapts the software to the cloud environment.
IT project data
- Industries energy
- Specialist tasks Migration
- DP tasks Migration
- System environments Client/Server, Cloud Computing
- Procedure model customer standard
- Programming languages C-Sharp
- Databases Azure SQL DB, Oracle Database
- Development and test tool MS SQL Server Migration Assistant (SSMA), MS Visual Studio .NET
- Middleware and frameworks Fluent NHibernate, NHibernate
Project period01.02.2019 - 15.08.2019
Customers who trust us
Have we sparked your interest ?
