Project description MIGRATIONS PROJECTS

Microsoft development, database development and database administration, web portals and OO development...

SSIS packages analysis for migration SQL Server 2010 to Microsoft SQL Server 2018 - MSSQL T-SQL, SSIS, ETL

Mann+Hummel

MSSQL, T–SQL, SSIS, ETL

Mann+Hummel, Speyer, Germany

PROJECT LINK: Not available
Persons in the PROJECT: Stefan Troehler
PROJECT Duration: Oct 2018 - Nov 2018
PROJECT value: SFR. 00,000.00

Migrationen

Project portfolio
0
HOURS REQUIRED
0
CUP OF COFFEE
0
LINES IN THE CODE
0
EXPERTS IN THE PROJECT

Development of a concept for the cost-effective migration of 600 SSIS packages, consisting of an analysis of all existing packages, division of the packages into three groups, submission of the concept including calculation of the time required for migration as well as the development of several options for a cost-effective implementation of the entire migration. The implementation takes place partly with employees in-house, with students and with migration specialists. The concept also takes into account a performance optimization of the individual SSIS packages.

  • Analysis of all existing packages (600 SSIS packages).
  • Developing a concept for the most cost-effective migration taking into account:
  • Performance increase for DWH packages.
  • Migration of SAP packages.
  • Migration of own components.
  • Migration of standard components.
  • The 30-page analysis contains the complete procedure for the 600 SSIS