SQLCompare.Engine.Triggers not implement IDatabaseObjects?

Dan F

Hi

Any particular reason why RedGate.SQLCompare.Engine.Triggers doesn't implement IDatabaseObjects? Makes it sort of painful to generically deal with all the objects in the database as collections of IDatabaseObject objects. No biggie though

Cheers
Dan

Andras B

Dan F wrote:

Hi

Any particular reason why RedGate.SQLCompare.Engine.Triggers doesn't implement IDatabaseObjects? Makes it sort of painful to generically deal with all the objects in the database as collections of IDatabaseObject objects. No biggie though

Cheers
Dan

Hi,
the reason is that we do not provide a top level trigger collection. All the triggers are table scoped. You are right that trigger names, unlike index names, must be unique within a database, and it would be possible to identify a trigger based on its fully qualified name. We will consider your request for our future releases.

Regards,
Andras

Dan F

Yeah, makes sense for sure. I get access to the triggers via the table's script regions which is fine and dandy for my purposes. It'd be nice to see them as proper top level objects, but it's hardly killing me. Thanks for the reply! Rock on