Enhanced project options

Compares and synchronizes SQL database content.

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

Enhanced project options

Postby markcw » Tue Mar 20, 2012 7:48 pm

We just upgraded to SQL Data Compare 10.

I propose project options for a new category called 'Comparison Results'. The options would be for the comparison results report only. This is used by us to export data value changes to a spreadsheet and given to a client to verify before applying any updates.


Comparison Results

- Show Identical Column Values as Blank in Results - default no.

I want to check this option so the Comparison Results will show blanks in the columns that are equal. When exported as a spreadsheet, a client can view at a glance what are the column values that differ. I have seen a similar request to export highlighted columns in the spreadsheet when the data values are different but this could be an alternative.


- Show null as blank in Results - default no.

I want to check this so the Comparison Results will show blanks in any column with null. When exported as a spreadsheet, a client would not see NULL in a column.


- Show Column Values when both are identical in Results - default yes

I want to uncheck this option so the Comparison Results will only show columns with 1 row difference in the data values. This would avoid viewing the Comparison Results and then changing the project table/view options to only compare columns when a difference from the last compare is highlighted.
markcw
 
Posts: 10
Joined: Tue Dec 13, 2011 10:34 pm

Postby andy.campbell.smith » Wed Mar 21, 2012 3:02 pm

Can I ask you to post this as a feature suggestion on our UserVoice forum here:

http://redgate.uservoice.com/forums/147 ... uggestions

We've been using UserVoice to keep track of feature requests for some of our other products for a while now, and we're just rolling it out for SQL Compare and SQL Data Compare - it lets us be a little more transparent with users, and because anyone can vote on the submissions it lets us focus on issues that are really important to our users.

Thanks!
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby markcw » Wed Mar 21, 2012 5:39 pm

Done
markcw
 
Posts: 10
Joined: Tue Dec 13, 2011 10:34 pm

Postby andy.campbell.smith » Fri Mar 23, 2012 12:45 pm

Thanks very much, we appreciate it!
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests