none
Export Schema Compare to HTML Report

    Question

  • 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

Answers

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: http://msdn.microsoft.com/en-us/library/hh550080(VS.103).aspx .

    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 

    http://blogs.msdn.com/b/ssdt/archive/2014/07/15/msbuild-support-for-schema-compare-is-available.aspx

    I believe this will cover your requirements. Regards,

    Kevin

    Monday, July 21, 2014 11:31 PM