Database Objects Comparison Tool

Laravel-based tool for comparing MS SQL Server database objects across multiple servers, reducing manual workload by 80%.

Overview

Internal tool developed for Farmaenlace pharmaceutical company to compare database objects (tables, views, triggers, etc.) across multiple MS SQL Server instances. Automates the comparison process and generates detailed reports of differences, significantly reducing manual database administration workload.

Technologies & Tools

Laravel

PHP

MS SQL Server

Bootstrap

Key Features

1Multi-server database object comparison (tables, views, stored procedures, triggers)
2Automated report generation showing differences between selected servers
3Table record count comparison across database instances
4User-friendly interface for selecting servers and objects to compare
5Detailed diff view for schema differences
6Export functionality for comparison reports

Challenges & Solutions

Cross-Server Query Performance

Challenge: Comparing large databases across multiple servers was slow and could timeout, affecting usability.

Solution: Implemented parallel query execution for independent comparisons, cached database metadata, and added progress indicators. Optimized SQL queries to retrieve only necessary schema information.

80% Manual Workload Reduction

Challenge: Database administrators spent hours manually checking differences between production, staging, and development servers.

Solution: Automated the entire comparison workflow with a single-click interface. Generated comprehensive reports highlighting all differences, allowing DBAs to focus on resolving discrepancies rather than finding them.

Project Information

Timeline

Sep 2017 - Sep 2017

Role

Backend Developer

Project Metrics

80%

Workload Reduction

1 month

Development Time