Exporting Comparison results to excel

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Exporting Comparison results to excel

Postby kgurung » Tue Aug 19, 2014 10:10 pm

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
 
Posts: 4
Joined: Tue Aug 19, 2014 9:45 pm
Location: Minnesota

Postby Brian Donahue » Fri Aug 22, 2014 3:01 pm

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
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby kgurung » Sat Aug 23, 2014 5:24 am

Thank you Brian...

Karma
kgurung
 
Posts: 4
Joined: Tue Aug 19, 2014 9:45 pm
Location: Minnesota

Thanks again

Postby kgurung » Tue Aug 26, 2014 10:30 pm

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
 
Posts: 4
Joined: Tue Aug 19, 2014 9:45 pm
Location: Minnesota


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests