This is one of 3224 IT projects that we have successfully completed with our customers.How can we support you?
Migration MS Access to SQL Server
Project duration: 2 months
Brief description
There are various specialist MS Access applications of varying complexity, which are primarily used for service reporting. These were developed by the department itself. The data is stored in MS Access databases. To improve stability and data security, the data storage is extracted from the individual MS Access applications and migrated into a separate SQL Server database.
Supplement
Within the scope of the project, the existing MS Access data structure is to be checked for compatibility with the SQL server. Furthermore, appropriate SQL scripts for table creation have to be created, the data has to be transferred from MS Access to the SQL Server databases and the functionality has to be tested against the MS Access front-ends. The migration is carried out with the support of the SQL Server Migration Assistant (SSMA) from Microsoft.
Subject description
The applications manage various data in the area of IT services and serve as a database for reporting, e.g. regarding SLA compliance.
Overview
- Industries banking
- Specialist tasks technical controlling
- DV tasks Migration
- System environment Client/Server
- Procedure model PTA project manual
- Databases MS SQL Server
- Development/ test tools MS Access, MS SQL Server Migration Assistant (SSMA),
Project period01.02.2018 - 01.04.2018
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
