Case Study: New Market Group (NMG) speeds database comparisons and synchronization with Idera SQL Comparison Toolset

New Market Group (NMG) - Customer Case Study

New Market Group (NMG), a small professional services company in Canada managing 25 to 49 Microsoft SQL Server databases, needed a better way to keep databases consistent across locations and handle slow VPN connections between offices. Using Idera’s SQL Comparison Toolset, NMG sought to compare schemas and data, synchronize databases, and automate batch jobs and scheduled comparisons.

Idera implemented SQL Comparison Toolset to run synchronization jobs at noon and after hours, helping NMG maintain identical schemas, resolve data issues, and roll out changes across multiple servers. The results included faster comparisons, automated synchronization scripts, smoother remote-office operation despite slow VPN lines, and improved support for upgrades, migrations, and verification of database replication.

New Market Group (NMG)

Jeffrey McMorran

IT Director