Filter
Top Products
Cisco Support Tools 1.0 User Guide How to Use the DBDiff Utility 165
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>