Columns in comparison feature

PDansereau

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

Chris Auckland

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