How can we help you today? How can we help you today?

Exporting Comparison results to excel

Hi,

I would like to export the differences to excel using the Generate Comparison Results Report. Unfortunately, it only gives me the object names for both the databases. Is there any way to get the SQL code to see what is the difference at the code level?

Thank you

Karma
kgurung
0

Comments

3 comments

Sort by
  • Brian Donahue
    Hello,

    Unfortunately, the XML for Excel report of SQL Compare does not show the DDL for any objects. You can still save as XML. Excel 2013 at least can open the "plain" XML file and you can see the creation scripts from both sides.

    Older versions of Excel may require you to supply the XSD (schema definition) so that Excel knows how to display the file. (see http://sdk.red-gate.com/index.php/SQL_C ... XML_import - you can extract the XSD from the XML Schema Collection).

    Otherwise, you can request this as a feature in Red Gate's Uservoice site: https://redgate.uservoice.com/forums/14 ... uery=excel
    Brian Donahue
    0
  • kgurung
    Thank you Brian...

    Karma
    kgurung
    0
  • kgurung
    Hi Brian,

    Just tried your suggestion and it worked for me. The XML file opens in Excel for me, so now I can proceed with what I want to do!

    Really appreciate the help

    Karma
    kgurung
    0

Add comment

Please sign in to leave a comment.