VIVID Housing Limited - SQL Server Database Analysis



Database services


Microsoft SQL Server

VIVID Housing Limited - SQL Server Database Analysis

VIVID required validation and verification that a database change planned to be deployed to production would be successful. They were concerned that some data could be lost, and it was not covered in their test plan.

Propel analysed two databases, one in a test environment and one in a production environment. A schema and data comparison was performed and a report was produced explaining the differences found.  Problematic fields were identified for the test plan and some additional recommendations to improve the performance of the SQL server database were also made.

The report provided VIVID with enough information to proceed with planning and testing the migration and the project was successfully delivered.