I have a number of databases all should be the same but I would like a better way to compare and validate the scripts that make up the DBes.
For instance I have say 500 tables and at the moment none of scripts that create the tables have version numbers so over time I don't know if I have the correct version of the script installed.
I also have the same issue with views say again 500 views as i have 10+ Databases I don't want to have to manually check each and every one as that's 10000 checks.
I thought the best way to tackle the issue would be to export just the tables and views and do a md5sum on each of them if they are different to the source then i know I have a difference.
how best to just export the scripts that make up the tables and views?
Thanks for your comments (in advance)