Red Gate forums :: View topic - CSV/Excel Summary
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

CSV/Excel Summary

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
barryryan



Joined: 16 Sep 2011
Posts: 5

PostPosted: Thu Oct 20, 2011 6:55 am    Post subject: CSV/Excel Summary Reply with quote

We are evaluating SQL Data Compare for testing purposes and want to save the comparison summary. Using Print Preview we can save as CSV, PDF, XLS.

We want to be able to manipulate and compare the summary values without retyping so XLS and CSV seem like good options.

However:

1. In the XLS export in a number of columns the numbers are actually individual images/picture objects rather than regular data cells so they can't be selected and are not useful for analysis (other than retyping the numbers which defeats the purpose). Is this a bug or a feature of the export functionality?

2. The CSV export only lists the number of identical rows - the other columns are erroneously empty as per the example extract from the CSV file below. Is this is a known bug or am I doing something wrong?

Type,All Different,Owner,Table Name,Source Only,Different,Target Only,Table Name,Owner,Identical
29 tables or views with differences in their rows,,,,,,,,,
Table,,dbo,AC_AgentsCommission,,,,AC_AgentsCommission,dbo,4459231
Table,,dbo,AI_AgentInquiry,,,,AI_AgentInquiry,dbo,509470
Table,,dbo,BI_BillingInformation,,,,BI_BillingInformation,dbo,1169758

Are there any other alternative exports that will provide me with the data without re-typing?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Thu Oct 20, 2011 2:41 pm    Post subject: Reply with quote

Thanks for your post.

I see what you mean, and it does look like a bug with the print function. However, a better way to export to CSV will be to use 'Tools' > 'Export comparison results'.

This will allow you to export a summary to CSV, but doesn't have the problem of having empty columns.

I hope this helps.

Regards,

Chris
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
barryryan



Joined: 16 Sep 2011
Posts: 5

PostPosted: Tue Oct 25, 2011 4:08 pm    Post subject: Thanks Reply with quote

Chris,

Thanks for pointing that out. I had used that before but got blinkered by the Print Preview issue. that will work for me.

Barry.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group