Red Gate forums :: View topic - Comparing Triggers, Indexes and Constraints
Return to www.red-gate.com RSS Feed Available

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

Comparing Triggers, Indexes and Constraints

Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
geoffrobinson



Joined: 21 Apr 2011
Posts: 3
Location: Philadelphia, PA, USA

PostPosted: Thu Apr 21, 2011 9:56 pm    Post subject: Comparing Triggers, Indexes and Constraints Reply with quote

When I compare two databases and examine the Differences collection, I see views, tables, functions and stored procedures.

I want to determine whether the triggers, indexes and constraints belonging to a particular table are the same. So that leads me to a few questions.

If a Difference is between 2 tables, do they get the value of DifferenceType.Equal only if all their triggers, indexes, and constraints are the same?

If not, can I test those types of objects against each other?

Thanks for any help in advance. Please let me know if I need to provide any additional information.
Back to top
View user's profile Send private message
Sian.Williams



Joined: 26 Aug 2010
Posts: 32

PostPosted: Mon Apr 25, 2011 11:44 am    Post subject: Comparing Triggers, Indexes and Constraints Reply with quote

Thanks for contacting Red Gate.

They will only be classed as equal if every attribute is equal, assuming you are not ignoring indexes, triggers and constraints.

You cannot treat indexes, triggers and constraints as individual objects at this time, although there is a feature request for it, it is logged as SC-2447. You can quote this ID if you wish to chase this up in future.
_________________
--------------------------------------
Siān Williams
Red Gate Software
Tel: 0800 169 7433
sian.williams@red-gate.com
--------------------------------------
Back to top
View user's profile Send private message Send e-mail
geoffrobinson



Joined: 21 Apr 2011
Posts: 3
Location: Philadelphia, PA, USA

PostPosted: Mon Apr 25, 2011 3:28 pm    Post subject: Re: Comparing Triggers, Indexes and Constraints Reply with quote

Sian.Williams wrote:
They will only be classed as equal if every attribute is equal, assuming you are not ignoring indexes, triggers and constraints.


Thank you for your response.

Is including indexes, triggers and constraints the default option? In other words, do I have to specify they are included or is it the default?

It sounds like they are included and you have to specify to ignore them.
Back to top
View user's profile Send private message
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