Cisco Systems DBDiff Utility: A Guide to Comparing Database Tables

How to Use the DBDiff Utility

Use the DBDiff utility to perform comparisons of database tables from two different databases. For example, you might want to check that the ICR_Locks table contains the same data on both sides of a Central Controller.

For use with nodes on which SQL Server is installed only.

To Access DBDiff from the Dashboard

To run DBDiff from the Support Tools Dashboard:

1.Use the System Select screen to select the system (namely, PG) you want to work with.

2.From the Dashboard menu, select Cisco Common Tools > DBDiff.

3.In the Arguments field, enter desired arguments, as described in the Using section below.

Note: When entering arguments, the dbdiff command is already implied. Do not enter it in the Arguments field.

4.Specify the command duration time or accept the default (60 seconds). This is the amount of time the command will attempt to run before terminating.

5.If desired, check Elevate Command Priority. This ensures the command will run regardless of the level of server activity.

6.Click the Run button.

To Access DBDiff from a Command Line on a Node

From a command-line on an ICM node on which SQL Server is installed, you can access DBDiff from any location on the drive on which ICM is installed. For example:

c:\>dbdiff

c:\temp>dbdiff

Using DBDiff

Syntax: dbdiff <database1.table@host1> <database2.table@host2>

Cisco Support Tools 1.0 User Guide How to Use the DBDiff Utility 165