Columns in comparison feature

Compares and synchronizes SQL database content.

Moderators: Chris Auckland, David Atkinson, richardjm, david connell

Columns in comparison feature

Postby PDansereau » Sat Jan 28, 2012 12:21 am

Hi,

I need 2 things from that feature and cannot figure how to achieve these:

1 - Systematically ignore some columns that are pervasive in our design, without having to go through a click festival.

2 - When ignoring a mandatory column, my inserts are failing. Is there a way to ignore a column in the comparison step but still insert it in the script step?


Thanks
PDansereau
 
Posts: 1
Joined: Sat Jan 28, 2012 12:14 am
Location: Montréal

Postby Chris Auckland » Mon Jan 30, 2012 8:51 pm

1 - Systematically ignore some columns that are pervasive in our design, without having to go through a click festival.


As you have found, there isn't an easy way to do this with the UI. We have just set up a uservoice site for SQL Data Compare, where users can view and vote for SQL Data Compare features. Would you be able to suggest this idea on there? https://redgate.uservoice.com/forums/14 ... uggestions

We have an example of how to do this with the API, but I don't know how helpful that will be:
http://sdk.red-gate.com/index.php/Exclu ... ified_name

2 - When ignoring a mandatory column, my inserts are failing. Is there a way to ignore a column in the comparison step but still insert it in the script step?


This request has been around for a while, and I'm pleased to say it is currently scheduled for the next version. Our internal reference for this is SDC-137
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests