How can we improve SQL Data Compare?

SQL Data Compare needs the cool functionality of exporting reports as HTML currently found in SQL Compare!

The below description moved from https://redgate.uservoice.com/forums/147879-sql-data-compare/suggestions/3137395--report-switch-similar-to-that-of-sql-compare:

> I would like to see SQL Data Compare get the /report switch like SQL Compare does. With SQL Compare I usually generate an interactive report to store along the generated script in our build process. This allows to review changes packaged into a given build. Having the same kind of reporting capability from SQL Data Compare would allow us to get the full picture of a given build's database changes (for static data, precisely).

76 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Alan GruverAlan Gruver shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    14 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • PaulPaul commented  ·   ·  Flag as inappropriate

        It would also be great to be able to provided the vendor of the actual live application with a formatted report. Showing what is different on each row.

      • PaulPaul commented  ·   ·  Flag as inappropriate

        I support the Data Warehouse of an Urgent Care Application. The client who are non technical users would like a formatted report of the differences that we have detected during external data refreshes for example.

      • Anonymous commented  ·   ·  Flag as inappropriate

        why did you remove this?
        unreadable csv file output - no good.
        the HTML report was one of the best features
        enough to make me stop using the latest version and go back to an earlier version of the tool
        :-(

      • SnehaSneha commented  ·   ·  Flag as inappropriate

        I vote for this and strongly encourage to get this incorporated in new release of the product. This would make the product more valuable as well.

      • Anonymous commented  ·   ·  Flag as inappropriate

        This would be a huge plus for our organization. Please add this to the next version.

      • Anonymous commented  ·   ·  Flag as inappropriate

        The DBA team gets a request from a developer to do a data compare - we'd like to give them an easily understandable report. We also get requests from the deployment team - can we push configuration differences from a beta db to a prod db? But they want a report first so they can say, push this table's differences but not this other table's differences.

      • David AtkinsonAdminDavid Atkinson (Admin, Redgate) commented  ·   ·  Flag as inappropriate

        This is definitely something we're considering, especially as these tools are used more and more for build processes such as continuous integration. Out of interest, could you describe briefly how your build process works?

      • Marc-AndreMarc-Andre commented  ·   ·  Flag as inappropriate

        I would like to see SQL Data Compare get the /report switch like SQL Compare does. With SQL Compare I usually generate an interactive report to store along the generated script in our build process. This allows to review changes packaged into a given build. Having the same kind of reporting capability from SQL Data Compare would allow us to get the full picture of a given build's database changes (for static data, precisely).

      Feedback and Knowledge Base