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