Use Tablediff to compare all tables

Posted by Davie on Stack Overflow See other posts from Stack Overflow or by Davie
Published on 2009-11-12T15:05:37Z Indexed on 2010/04/12 10:33 UTC
Read the original article Hit count: 286

Filed under:
|
|

Hi,

I have recently discovered the tablediff utility of SQL Server 2005.

I have 2 instances of the same database each on a different server.

Is it possible to compare all tables using tablediff without having to replicate the same command while only changing the table name?

For example, compare table1 on server1 with table1 on server2 then compare table2 on server1 with table2 on server2, until all tables have been compared.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql