Query to Find Database Differences

[mrfritz44]

Is it possible to run a single query to audit the row counts of the tables for an entire database?

My final goal is to find the tables that differ in terms of row count from two separate databases on two different servers.

Any help would be apreciated.

Thanks,

Fred

 

[vongrunt]

Single query - no. Single small batch or sproc - yes.

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[mrfritz44]

This needs to be done with Oracle SQL on an Oracle box.....any hints onthe syntax for that batch?

 

[SQLBill]

Most valuable hint: Post in an ORACLE forum on this site.

This forum is for Microsoft SQL Server.

-SQLBill

Posting advice: FAQ481-4875

 

[philhege]

FWIW, here's a DB-agnostic comparison tool:

http://www.dbbalance.com/products.htm

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Eschewing obfuscation diurnally.