SQL Data Compare 10.1 - Export Comparison Results

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

SQL Data Compare 10.1 - Export Comparison Results

Postby ProvidentFinanceKW » Thu Sep 06, 2012 2:12 pm

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?
ProvidentFinanceKW
 
Posts: 4
Joined: Thu Sep 06, 2012 2:05 pm

Postby stanori » Thu Sep 06, 2012 5:23 pm

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
stanori
 
Posts: 84
Joined: Mon Apr 23, 2012 1:13 pm

Postby david.brown1234 » Tue Mar 11, 2014 12:43 pm

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!
david.brown1234
 
Posts: 2
Joined: Tue Mar 11, 2014 12:17 pm

Bug work-around

Postby david.brown1234 » Tue Jun 10, 2014 11:24 am

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
david.brown1234
 
Posts: 2
Joined: Tue Mar 11, 2014 12:17 pm

Postby Sandy F. » Fri Aug 29, 2014 9:43 pm

I love Redgate products but it is amazing to me that this bug has still not been fixed. It was originally posted in 2011 and it is still a bug.
Sandy F.
 
Posts: 4
Joined: Tue Apr 28, 2009 2:23 pm


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests