SQLCompare multiple database and generate report

aperregatturv

We have around 8-10 different versions of database. I need to compare all 10 versions for update before we release. Right now, I created a batch file that copies pristine databases to a test folder and attaches pristine database of each version then run dbupdate[we created that uses SQL Toolkit] utility that uses snapshot file to update all the databases to the latest version. So far everything looks good.
Now, i want to create one more step to compare the updated databases with a pristine database created in the new version. The new database is created using a big script file.

My question is, how can i create batch file to do SQL Compare of all updated databases with pristine database and create a report which i can move to our internal webserver for others to look at.
This testing i do on a Dedicated Test PC but it does not have SQLCompare installed. We have SQLCompare installed on a different PC.

Please let me know how it can be accomplished or can I use SQLToolkit to do this if so, how?

Thanks
Arun

JonathanWatts

Hi there,

I have answered your query in your post on the SQL Compare v6 forum here: http://www.red-gate.com/MessageBoard/vi ... 9395#19395.

Thanks,

Jonathan