Upgrading the MS SQL database system

Client`s pains

Project size

In this project, we migrated SQL Server 2014 to SQL Server 2017.
Delphi icon
Delphi
Microsoft sql server
Microsoft SQL Server
VCL
VCL
sgcWebSockets
sgcWebSockets
LMD Tools
LMD Tools
Quick Report
Quick Report

Duration

2 weeks of work

Efforts

300 000+ lines of code

01.

Description

The software created by our client helps medical institutions in managing their finance. That’s why the volume of data that should be processed is continuously growing. The client contacted us with a request to enhance the process of managing data as their Microsoft SQL Server 2014 database couldn’t cope with system loads. Moreover, it was necessary to reduce expenses on data storage and computing. However, during our cooperation, the company acquired a new business structure and our new task was to integrate a database. We set the timeframes and resources required for this project.

02.

Solution

The key task was to update a database up to Microsoft SQL Server 2017. As the client works in an industry with strict regulations, we had to study the niche and detect all possible risks related to cybersecurity and sensitive information protection.

The main system based on SaaS had a function of automated data processing that was not presented in another system. The data architectures were completely different and we had to find an answer to the question of how to unite databases with different data formats and resources. We initiated the process of data transformation.

In order to unite all the data of the organization, our team started to unify data. This process presupposed the structuring of unprocessed data from multiple flows, including incomplete and isolated data sets.

As a result, we built a new data architecture that corresponds to the needs of the company. Then, we proceeded to migration of a database from SQL Server 2014 to SQL Server 2017.

We defined the following stages:

  • Estimations and planning
  • Data encryption and backup 
  • Migration
  • Testing

Migration to a new MS SQL Server let the system faster process bigger volumes of data. Optimized SQL requests allowed us to reduce the time required for execution which ensures immediate software reaction to user’s requests.

03.

Summary

  • As a result of migration, system performance increased by 2 times.
  • New possibilities of MS SQL, including automated database setting, smart differential backup, and security enhancement, helped to significantly reduce maintenance expenditure. Now developers spend less time on debugging and systems upgrading.
  • Thanks to the timely conducted migration, our client not only reduced its IT budget on software maintenance but also could observe higher end-user satisfaction.

Related Projects

Our experience with other projects

Amberteq helped customers to release their business ideas into up-to-date solutions implemented via the most current development stack. Take a journey through the projects with our team to experience it with us.

WANT TO START A PROJECT?