| Author |
Message |
PDansereau
Joined: 28 Jan 2012
Posts: 1
Location: Montréal
|
 Posted: Sat Jan 28, 2012 12:21 am Post subject: Columns in comparison feature |
 |
|
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 |
|
| Back to top |
|
 |
Chris Auckland
Joined: 24 Oct 2006
Posts: 710
Location: Red Gate Software Ltd.
|
| Posted: Mon Jan 30, 2012 8:51 pm Post subject: |
|
|
| Quote: |
| 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/147879-sql-data-compare-feature-suggestions
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/Excluding_all_columns_with_specified_name
| Quote: |
| 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 |
|
| Back to top |
|
|
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
