- Argusa
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.