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

How can we support you?

Weißes Quadrat mit umrandeten Seiten rechts oben

Migration of MS SQL Server 2008R2 to MS SQL Server 2016

Project duration: 1 year, 3 months

Brief description

The existing system, which runs on SQL Server 2008R2, is migrated to SQL Server 2016. This migration also involves converting the development environment from Visual Studio (VS) 2008 to VS 2015 and converting version management from Team Foundation Server (TFS) to TFS 2015. In addition, certain new safety requirements are taken into account, such as server hardening, for example. The operating system is changed to Windows Server 2012R2.

Supplement

The environment consists of one development server and QA server each for the SQL server databases and the OLAP systems. An SQL server is used for the production system. This SQL server supplies data to seven OLAP servers and a process control server that is also used as the archive server for historical OLAP databases.

Subject description

The key performance indicators database shows the company's actual and planned sales around the world at the level of individual articles, in terms of value and quantity. Target figures can be used together with up-to-date actual figures on a monthly basis to create analyses. The key performance indicators include values for the working capital, sales figures and manufacturing costs, value management, and employee figures and costs. The itemized items are available in both consolidated and unconsolidated form, which enables the value of the entire manufacturing process to be checked. In addition, data is provided for a detailed deviation analysis. The database enables planners and controllers to evaluate the KPIs in more than 12 dimensions. These dimensions are integrated into the management reporting concept for an existing analysis database at a rougher level.

Overview

Project period01.10.2016 - 31.12.2017

Have we sparked your interest?

Portrait Herr Knudsen, Mann im Anzug

Ole Knudsen

Key Account Manager

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.