• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 517
  • Last Modified:

Run tablediff for all user defined tabes and save result in a directory

I do run tablediff command to identify if any difference between two tables(Table names are same) from two different databases and store result in C: as file name as Tablename.txt.

I've two databases both contains same schema. I mean same number of tables and with same table names. I would like to compare ALL the user defined tables between the two databases and like to save the result as <TABLENAME.txt> in a specific folder.

Doing each table by table is cumbersome. I would like to perform this in one shot.

Please do guide me how to achieve this.?
0
Easwaran Paramasivam
Asked:
Easwaran Paramasivam
1 Solution
 
PortletPaulCommented:
please refer to this:
http://stackoverflow.com/questions/1722846/use-tablediff-to-compare-all-tables

there a script there that should do what you want.

but the author of that scripts points to this page:
The shortest, fastest, and easiest way to compare two tables in SQL Server: UNION !

as an alternative to tablediff, and there are other similar comments there also.
0
 
Easwaran ParamasivamAuthor Commented:
Thanks.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now