Exporting Comparison results to excel
kgurung
Posts: 6
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
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
Comments
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
Karma
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