in reply to Automated checking for identical MS SQL tables

Win,

Just because the table sizes are the same, does not Necessarily mean that the data is identical. You may want to read up on replication for your chosen database platform.
Check out Replication Developer InfoCenter on msdn

Hoep this helps.

Martin
  • Comment on Re: Automated checking for identical MS SQL tables

Replies are listed 'Best First'.
Re^2: Automated checking for identical MS SQL tables
by Win (Novice) on Jan 13, 2006 at 14:18 UTC
    Replication perhaps is an issue that I will have to look at, although I was expecting to replicate the SPROCS through a Perl program that I have and the tables through the enterprise manager.

    I guess that I could write a Perl program to look at the number of rows in each table, for each database, and then make sure that they tally. Although this does not guarantee that the tables have not been tampered with, it will probably be good enough for my purposes.