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.