| Author |
Message |
geoffrobinson
Joined: 21 Apr 2011
Posts: 3
Location: Philadelphia, PA, USA
|
 Posted: Thu Apr 21, 2011 9:56 pm Post subject: Comparing Triggers, Indexes and Constraints |
 |
|
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 |
|
 |
Sian.Williams
Joined: 26 Aug 2010
Posts: 32
|
| Posted: Mon Apr 25, 2011 11:44 am Post subject: Comparing Triggers, Indexes and Constraints |
|
|
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 |
|
|
geoffrobinson
Joined: 21 Apr 2011
Posts: 3
Location: Philadelphia, PA, USA
|
| Posted: Mon Apr 25, 2011 3:28 pm Post subject: Re: Comparing Triggers, Indexes and Constraints |
|
|
| 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 |
|
|
|
|
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
