Delphi
Microsoft SQL Server
VCL
sgcWebSockets
LMD Tools
[breadcrumb]
Upgrading the MS SQL database system
Client`s pains
- The use of our obsolete database leads to problems with the realization of our business processes.
- It can’t cope with loads of a huge system.
- We’d like to reduce expenses on data storage and computing.
Project size
- 2 weeks of work
- 300 000+ lines of code
- 80 tables in the database
- 50 reports in SQL Server Reporting Services
In this project, we migrated SQL Server 2014 to SQL Server 2017.
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.