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,

Unfortunately the reporting code is loacted in user interface which isn't part of the Toolkit license. So if you want to use the toolkit to generate reports, the only way to do it is to read the results and generate a report by hand.

I know this isn't ideal so have raised a request to get this moved from the private UI code to the public API.

However, if you are already using a batch file, then perhaps using the SQL Compare command line would be your best bet. You can do pretty much everything that you can do with the toolkit, plus it does also allow you to gain access to the html reports that are in the UI.

Hope this helps,

Regards,

Jonathan

Brian Donahue

The command-line is the easiest and most foolproof method to make a report, but there is some sample code that you may be able to use if you really, really need to generate a HTML report in your own code here.

aperregatturv

Jonathan, Brian,

Thanks for the reply. I think i will go with both of your suggestions

1. I would like to know what are the commandline options to compare.
Pristine database with updated database. I will add this code to batch file which will run on all databases.

2. As Brian suggested, sample code that i can access generated HTML report. Please how i can do that.


Thanks
Arun

Brian Donahue

The Toolkit report sample code topic is available through the link I put in my previous reply. Here is the full URL:

http://www.red-gate.com/messageboard/vi ... ?t=505#top

aperregatturv

Brian,

Thanks for the quick reply. I will give a try.

Thanks
Arun

aperregatturv

I tried the SQLCompare.exe commandline executable and it asked to ReActivate my copy of SQL Compare Command Line and I did i got a message saying it was successfull. But, after this when i tried to run the command line its asking me again to activate. what am I doing wrong here?

Thanks
Arun

Brian Donahue

Hi Arun,

You need a 'Professional Edition' licence for SQL Compare in order to use the command-line application. I suspect you have the Standard Edition. You can check your invoice to see which edition you have.