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.?