This is one of 4124 IT projects that we have successfully completed with our customers.

How can we support you?

Weißes Quadrat mit umrandeten Seiten rechts oben

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

Project period01.02.2018 - 01.04.2018

Have we sparked your interest?

Portrait von Dr. Tim Walleyo

Dr. Tim Walleyo

Member of the Management Board

Jetzt Kontakt aufnehmen

Zum Umgang mit den hier erhobenen Daten informieren wir in unserer Datenschutzerklärung.

Contact now

We provide information on the handling of the data collected here in our privacy policy.

Download file

We provide information on the handling of the data collected here in our privacy policy.