Red Gate forums :: View topic - SQL Data Compare 10.1 - Export Comparison Results
Return to www.red-gate.com RSS Feed Available

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

SQL Data Compare 10.1 - Export Comparison Results

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ProvidentFinanceKW



Joined: 06 Sep 2012
Posts: 4

PostPosted: Thu Sep 06, 2012 2:12 pm    Post subject: SQL Data Compare 10.1 - Export Comparison Results Reply with quote

I have a problem with the Export Comparison Results tool on SQL Data Compare 10.1. The dialog has tickboxes which allow the user to select a subset of the compare results. When I untick all but the Different box I expect to get the results only for the records with differences. However I get all of the records whether they are identical, different or missing from one of the tables.

Am I misunderstanding how this is supposed to work or is there a bug here?
Back to top
View user's profile Send private message
stanori



Joined: 23 Apr 2012
Posts: 76

PostPosted: Thu Sep 06, 2012 5:23 pm    Post subject: Reply with quote

Hi ProvidentFinanceKW,

Thanks for your post. The issue you are seeing with the Export Comparision Results is a bug. Our developers our aware of the issue, and this has been reported under SDC-1206.

Sorry for the inconvenience.
_________________
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
Back to top
View user's profile Send private message
david.brown1234



Joined: 11 Mar 2014
Posts: 2

PostPosted: Tue Mar 11, 2014 12:43 pm    Post subject: Reply with quote

I am seeing exactly the same behaviour as 'stanori'. Has this bug been fixed in newer versions of SQL Data Compare? It ought to be easy to fix!
Back to top
View user's profile Send private message
david.brown1234



Joined: 11 Mar 2014
Posts: 2

PostPosted: Tue Jun 10, 2014 11:24 am    Post subject: Bug work-around Reply with quote

Fortunately there is a way to separate out the different categories of result, as will now be defined.

• Export the results returned by a comparison by clicking Tools -> Export Comparison Results -> Export. (Note that this won’t work if a results file of the same name already exists in the chosen location.)

• Import the results into Excel as a comma separated text file, then order the data on the #tag column.

There are four possible values in this column, indicated the type of data in that row:
#a - only in source
#b - different in source and target
#c - only in target
#d - identical in source and target
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