Compare two database Tables, row count in each table which are in different servers

Database

Compare two database Tables, row count in each table which are in different servers

Hi All,
Please help me, we recently implemented new production box which is replica of old production box
now our management want to compare the tables and row count on old and new boxes for each database.
what is the best way to do this.

Is there any sql script that will pull all the tables and row count from old box first and again new box.

Thanks Advance.
Stan
5 REPLIES

Re: Compare two database Tables, row count in each table which are in different servers

Hello. Have you had any luck with your post from 16-Aug-2011? I am running into the same situation and would like to know if you found a solution.

Fan

Re: Compare two database Tables, row count in each table which are in different servers

In Oracle, TOAD has a feature that can compare 2 schema (or Databases in Teradata's term) (local and/or remote) of all objects DDL definitions (columns presision, indexes, constraints PK,FK .. whole 9 yards) AND gererate a big alter DDL scripts that can make these 2 schema logically matching.

Is there any comercially availabe tools for Teradata can do the same thing too ? if anyone can point us the URL and priceing will be greatly appreciated.

Or 2nd chose will be that ... if there is any utility Macro or storeproc that we can download to perform this task will be also great too, (this may be a better option for technical person, then he can custimize or even improve upon it)

Thanks in advance.




Senior Apprentice

Re: Compare two database Tables, row count in each table which are in different servers

The suisse army knife for Teradata DBAs and developers is AtanaSuite :-)

http://www.atanasuite.com/

The DeltaTool is all you need, it's included in all versions but Essential.

Dieter

Enthusiast

Re: Compare two database Tables, row count in each table which are in different servers

Yep, if we had AtanaSuite but many do not.

Enthusiast

Re: Compare two database Tables, row count in each table which are in different servers

wow... a response like that almost a year and a half later... gave me a good belly laugh!  :)