A new breed of tools for managing multiple SQL Server instances

We make tools that address some of the issues caused by running multiple SQL Server instances. Be it, keeping two instances in sync for recovery purposes or scaling out to 200 servers; our tools will help.

OmniCompare Overview

OmniCompare Logo

OmniCompare compares a growing number of settings and uses some logic to ignore false positives, such as differences with server names within jobs. The list of what we compare is still growing and being tuned to work with older systems but here’s the current list.

"I am definitely adding OmniCompare to my list of great SQL tools." - Sheldon Hull (@sheldon_hull)

Why should I try OmniCompare?

  • Full comparisons or partial comparisons; just checking jobs, versions, users etc.
  • Synchronising the estate. Keep all of your servers synchronised, taking some of the guess work out of service issues and misbehaving servers.
  • Auditing the estate. You can easily compare every server (tested up to 200 but contact the team if you need more).
  • Testing / Performance Tuning. Create a backup of the configuration before making changes during testing. Store the output with your test results so you can look back and recreate the exact configuration during the tests.
  • Compare single output files to check for differences over time.
  • Share configurations with colleagues or use saved configurations as a reference.
  • Create example files to distribute with your software to aid installations.
  • Use OmniCompare to remotely check customer configurations, reducing support costs and turnaround times.

What does OmniCompare compare?

  • Naming (server, instance etc.).
  • Version information (version, edition, service packs, cumulative updates etc.).
  • Instance configuration settings (memory, fill factor, max worker threads, recovery interval, CLR settings, compression settings etc.).
  • Instance properties (clustering info, edition, service pack & patch level information etc.).
  • Database settings (auto shrink, snapshot isolation, page verify option, CDC, CT, compatibility level, recovery model etc.).
  • Database file settings (auto growth, initial size, naming, state).
  • Users & permissions.
  • Assemblies (creation / modification date, CRL name etc.).
  • Service information (account, start up type (manual or automatic)).
  • Registry information (Port, working directory etc.).
  • Server (DDL) triggers.
  • Endpoint information.
  • SQL Server Agent Jobs.
The program is currently in beta so expect bugs, but please let us know if you come across any and send in your logs.
OmniCompare Logo Wide

Download OmniCompare

Download the latest version of OmniCompare (currently beta).

OmniCompare Roadmap

OmniCompare Roadmap

Look at what's in store for OmniCompare and share your thoughts.

OmniCompare Release Notes

OmniCompare Release Notes

Release notes provide information on the features and improvements in each release.

Send us a message

Other ways to reach us