Migrate without stopping the port
The port had to move from SQL Server 2008 to SQL Server 2019 while keeping the database that supports port activities operational.
CASE STUDY / LOGISTICSHandling
Handling
Docker
Business continuity, even when there are no breaks.
01 / MIGRATIONA leap in version,
A leap in version,
without stopping the port.
We helped a major Italian port migrate its operational database from SQL Server 2008 to SQL Server 2019.
2008Starter version
2019New Platform
24/7Continuous operation
A version jump of this type requires attention to the functional differences and performance between the starting and target environment. Thanks to our tools, we simulate the transition and identify the best configuration in advance.
We carry out the tuning interventions before the actual migration. Our experience allows us to operate even in 24/7 environments, without modifying the applications and without requiring service interruptions.
Before the switch, we collect workload data, evaluate configuration, storage and application dependencies, and define an action plan with priorities and verification criteria.
We use QMonitor to observe SQL Server before and after the intervention, so assessment, migration and implementation remain verifiable even in a 24/7 operating environment.
Tuning before the switch
We evaluated functional and performance differences, simulated the scenario and carried out tuning interventions before migration.
Collection and comparison of evidence
We analyzed workload, configuration, storage and application dependencies, defining priorities and verification criteria with QMonitor.
An updated platform
The migration has been designed for a 24/7 environment, without changing applications and without requiring service interruptions.