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