Project Management of Data Migration to MSSQL

How 7N led a successful transition from mainframe to Microsoft-based technology​

09/20/2023
#

CHALLENGE

Navigating complexity in core platform migration


A leading provider of digital mail and document services aimed to modernize its core platform by migrating from a costly mainframe system to a Microsoft-based technology stack.

The project initially focused on transferring a large-scale database to Microsoft SQL Server (MSSQL), but the scope expanded to include:

  • Developing and optimizing new software for the updated platform

  • Replacing legacy databases with object storage solutions

 

These additions increased complexity, making effective project management crucial to mitigate risks such as data loss and service disruptions.

​Jens Riis is one of our excellent, high-performing IT consultants. His outstanding effort was recently emphasized in his role as the Project Manager of a complex data migration project at one of 7N’s clients, a vendor for digital mail and document services. Taking over from previous project managers, our client found the right match in Jens, who had the competencies required to make the project succeed.

SOLUTION

Risk-free migration

To ensure a smooth transition, 7N provided an experienced consultant to lead the project. The consultant played a critical role in:

Comprehensive planning
Developing a structured migration strategy covering data transfer, software development, and system optimization

Team leadership
Managing a multidisciplinary team to navigate technical challenges and ensure alignment with business objectives

Risk management
Implementing measures to prevent data loss and minimize downtime, ensuring a seamless transition

Recognized excellence

The client’s management team granted Jens a great amount of support and trust in his competencies to make the project succeed. The CEO states: “If it is not specifically stated anywhere, I want you to know how proud you should be. You have been absolutely outstanding throughout the process - and even though we have done a lot of things wrong along the way, the biggest mistake is probably that you were not on the project from the start.”

IMPACT

Seamless core platform modernization

After thorough preparation, the team

Migrated the database to MSSQL

Optimized software for the modernized platform​​

Replaced outdated databases with object storage

The core platform was briefly shut down for the first time, allowing a seamless two-day transition with no disruptions.

Find out more

Explore our other

case studies

Dive into

IT insights

How can we help?

We provide IT services with the range and flexibility to manage the complexities of your unique digital challenges.