SQL Compare HTML Report Images
SteveGTR
Posts: 91
The HTML reports generated by version 10 of SQL Compare reference a link on your site that is no longer valid. The javascript in the HTML files has the following code:
var imagesdir = "http://www.red-gate.com/scimages/";
If I attempt to navigate to that on your website it comes back with:
Something's gone horribly wrong...
404: Page not found
Here's one of the images that can't be found on the report:
http://www.red-gate.com/scimages/NotEquals16.gif
Is there a new location for this? Or better, can you redirect request to the new location so that SQL Compare 10 will still function?
Thanks,
Steve Miller
var imagesdir = "http://www.red-gate.com/scimages/";
If I attempt to navigate to that on your website it comes back with:
Something's gone horribly wrong...
404: Page not found
Here's one of the images that can't be found on the report:
http://www.red-gate.com/scimages/NotEquals16.gif
Is there a new location for this? Or better, can you redirect request to the new location so that SQL Compare 10 will still function?
Thanks,
Steve Miller
Comments
I downloaded SQL Compare 11.2 and generated an HTML report to see if I could find the new URL for the images.
To my surprise the JavaScript still points to the now invalid broken link in this line:
var imagesdir = "http://www.red-gate.com/scimages/";
But, the variable is not used so no problem, for version 11.2 that is...
Instead, I see that the images are now encoded in the JavaScript. This is done in the setupImage function.
I swapped out the old setupImage with the new one, with the encoded images, and the old report looks great.
I'll just swap out the function. My PowerShell processing that utilizes the HTML report massages the generated report anyways.
I'm still disappointed that you'd break older versions. Maybe this was done by accident, but it should be fixed for people still using the older version. We're talking, in my case version 10.7, whereas the latest version I just download was 11.2. This isn't a huge time difference in terms of versions.
C:Program FilesRed GateSQL Compare 10
Found SQLCompareInteractiveReportTemplate.xsl
If you swap out the setupImage routine with the 11.2 version that encodes the images, the reports work.
Note, this code continues in the next message. There's a limit to the size of a message in the forum.