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 4813 IT projects that we have successfully completed with our customers.How can we support you?
Modernization of an existing Access departmental system
Brief description
The support of a complex departmental system can no longer be guaranteed by the original service provider. This isolated solution, which has grown over several decades, is transferred to the infrastructure supported by the IT department after a technical analysis has taken place in advance.
Supplement
The previously used Access-based data storage will be replaced in favor of an SQL Server-based solution. The integrated user administration is supplemented by a connection to the central system used throughout the company and the login procedure is converted to a single sign-on approach. In addition, the central logging system and existing master data management will be integrated.
Subject description
The technical redesign of the backend of the solution and the connection of central resources are intended to create the basic possibility for qualified support and maintenance of the system by the IT department. In addition, simplifications and optimizations in the technical structure are to be used to significantly reduce the costs of system operation. For example, the use of central data pools eliminates costly duplicate maintenance work.
IT project data
- Industries energy
- Specialist tasks software development
- DP tasks Migration
- System environments Client/Server, technical data processing
- Procedure model customer standard
- Programming languages T-SQL (Microsoft)
- Databases MS Access, MS SQL Server
- Development and test tool MS Access, MS SQL Server Migration Assistant (SSMA)
Project start01.03.2021
Customers who trust us
Have we sparked your interest ?
