Database migration from Oracle to SQL Server

Client

A major watchmaker in Geneva

Context

Matthieu is an IT manager and decided to switch to a new technologies due to lower licence pricing. The database, written in PL-SQL needs to be converted in T-SQL.

Projects and Results

Team Argusa helped Matthieu and accomplished the migration of the database (40 tables with complex loading logic) in 20 days. This includes :

• The implementation of the tables and the loading logic

• Verifications that the result matched the old technology

• Implementation of a system to monitor the loading duration, delay and volumes

• Implementation of post-loading quality check

• Documentation

Tools

SQL Server, Oracle, Tableau

Challenges solved

The data in the source system for the new technology was not present and the development needed to be done with the highest attention as it was not immediate to test the results.