Export Schema Compare to HTML Report


  • I've downloaded and installed the latest SQL Server Data Tools for VS 2012.  Is there anyway to export the results of the schema comparison into a report in CSV/Html format?  I understand that it can generate the sql diff script, but I want a readable report that I can use to show to people.
    Thursday, January 03, 2013 10:18 AM


All replies

  • Hi Carel, 

    This is an interesting suggestion but at this time there is no built-in support csv/html output.  As a workaround, you could process the diff script to produce such an output, or, as an alternative, consider using SqlPackage.exe with the DeployReport action, which will produce an xml report that you can perhaps process more easily.  You can find out more about using SqlPackage.exe here: .

    Thanks for your feedback. 

    Sunday, January 06, 2013 7:06 PM
  • PLEASE!  Add the ability to save/export the schema comparison results.  Why, or I should ask how, was this feature left out?  The results are there and displayed for me to see within Visual Studio - why would your restrict the developer from saving these results, even if just a copy and paste to a text file???  This is baffling to me.
    Monday, July 21, 2014 8:03 PM
  • Hi Sean, I think you'll be interested in the recent blog post covering how to generate schema comparison results using MSBuild. This is a command line tool but it supports saving results to a file and event using a custom XSD to define the report contents if the defaults aren't what you want. The blog post is at

    I believe this will cover your requirements. Regards,


    Monday, July 21, 2014 11:31 PM
  • It is a huge oversight to not have the ability to print the comparison results! Please make it a feature in a future release ASAP!
    Friday, May 01, 2015 2:06 PM
  • You can copy / paste from the results grid. If you RIGHT click in the grid then you can "Select All" and then copy and paste again using Right click. The problem that I have is that if you paste into excel then the formatting is lost so its no easy to see what the differences are. These are highlighted in bold in the sql compare grid. 
    Monday, June 01, 2015 2:39 PM
  • I find no way to copy from the results schema compare grid. Right clicking only gets me a submenu with Include/exclude options.
    Thursday, November 17, 2016 5:09 PM
  • The problem with all the suggestions is that you don't get any of the actual content differences apart from in the UI. This makes QAing a release with several developers very difficult meaning we have to share the screen with no easy way to record the differences, who approved and which user story they related to.

    The XML report doesn't do the same thing as the diff, it provides a report of what changes are going to be made (i.e. 1 drop and 1 create could be due to a single change in the diff). So not a good substitute.

    So I would suggest 

    1. Ability to export the compare to an excel file with 1 row per difference and comments showing before and after content (perhaps even differences bolded)

    2. Improve change log so it has one row per difference with actions

    3. Align the publish and compare engines so they can take in the same CmdSqlVariables. As this often creates differences during compare that wouldn't happen during publish.


    Monday, February 06, 2017 10:04 AM