Is it possible to view the SQL Data Comparison in htmlformat

phanim4uphanim4u Posts: 4
edited February 14, 2017 5:24AM in SQL Data Compare 11
Hi,

I had downloaded SQL Data Comparison trail version and tried comparing two table data, in the application the data comparison view was good but when i export the report it is storing in .csv where the view is not good. so is it possible to view the data results in html format?

Also is there an option for comparing the data using Custom Queries?

Thanks,
Phanindra Mokkapati

Comments

  • Hi Phanindra,

    You can export to an html file as well as a PDF and many other types of file. To do so, in the file menu click print preview. Then in the print preview window, go to the file menu and click on export document and choose the type of export file.

    More details can be found here: https://documentation.red-gate.com/display/SDC11/Exporting+the+comparison+results

    Hope this helps!

    Kind Regards,

    Joel Adams
    Product Support Team
  • JonCollinsJonCollins Posts: 4 New member
    Exporting the print preview only provides the mapping / comparison selections, and a summary of the results.
    It seems that the only option for exporting actual data results is the .csv export which, as noted above, is not very friendly.
    Surely it wouldn't take much to render the detailed results table from the UI into HTML? Alternatively a simple XML schema, rather than CSV, would enable integrators to write eg. XSLT to automatically render results into various machine-readable forms.
Sign In or Register to comment.