Red Gate forums :: View topic - Columns in comparison feature
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

Columns in comparison feature

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
PDansereau



Joined: 28 Jan 2012
Posts: 1
Location: Montréal

PostPosted: Sat Jan 28, 2012 12:21 am    Post subject: Columns in comparison feature Reply with quote

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
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon Jan 30, 2012 8:51 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic 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