Cisco Systems 1.0 (1) Manual De Usuario

Cisco Support Tools 1.0 User Guide 

How to Use the DBDiff Utility   165 

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 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. 

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

 

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