CATALLAXY SERVICES

The Index Comparer

The Index Comparer is a simple set of tools designed to help you compare indexes in two separate databases. There are three components to the Index Comparer:

1. The core business library
2. A console application to give an example of automation
3. A Windows application (see the download link on the left) which gives you a friendly GUI

Screen Shots

Click each of the screenshots for a larger image.

The main screen, before performing a comparison.

A listing of results grouped by table.

A listing of results not grouped by table.

A sample create script.

Extensibility

You can use the core Index Comparer functionality to, for example, perform automated comparisons of different databases and generate the relevant drop and create index scripts for your review.

The primary item left on the to-do list is to create an example of this as a Powershell script. Because the business object code is freely accessible (packaged in a link on the left), you may also use the core methods for your own purposes. If you do extend the code, send us an e-mail--we'd love to hear about it.