ERwin Triogger Bug

**Erland Sommarskog** · Jul 20 '05, 12:53 AM

Re: ERwin Triogger Bug

John Posada (jposada@book.c om) writes:[color=blue]
> I have bunches of tables and for some tables, I have
> triggers...anyw here from 1 to 6 of them for a table. Yesterday, I
> noticed that triggers appeared in SQL Query Analyzer that didn't
> appear in ERwin and after a long conversation with CA tech support, it
> was determined that ERwin doesn't properly support showing all
> triggers for a table when more than one trigger for that table
> performs the same action; insert, uipdate, or delete. When it finds
> more than one, it only shows one of them and ignores the others.
>
> As anyone found this to be true? There is a kludge workaround...us e
> SQL Enterprise to script out the database, then perform a reverse
> engineer on the script rather than the database, but that sucks.[/color]

I don't use ERwin, but PowerDesigner from Sybase. Whether PowerDesigner
can handle this situation nicely, I don't know, because I don't have
triggers in PowerDesigner, and I never have more than one trigger
per action for the same table.

However, unless the ERwin documentation clearly says that ERwin handles
this, I find it difficult to call it a bug. Sounds more like a limitation
to me. To make an analogy: in PowerDesigner you can only have one table
constraint per table.

As for having more than one trigger per action for a table, I am inclined
to say that just because this feature is there, does not mean that you
have to use it. Since the execution order is undefined, this seems
somewhat risky to me. (Unless you have one INSETEAD OF and one AFTER
trigger for the same action.)

--
Erland Sommarskog, SQL Server MVP, sommar@algonet. se

Books Online for SQL Server SP3 at

Microsoft SQL Server

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Get the flexibility you need to use integrated solutions, apps, and innovations in technology with your data, wherever it lives—in the cloud, on-premises, or at the edge.

**Erland Sommarskog** · Jul 20 '05, 12:53 AM

Re: ERwin Triogger Bug

John Posada (jposada@book.c om) writes:[color=blue]
> Second, about it not being a bug, I'm not asking ERwin to allow me to
> create more than one trigger...that situation already exists. I'm only
> asking it to show me an accurate representation of what it is.[/color]

If ERwin does not have the capabilities to create more than one trigger
on a table, I would expect it to be able to display more than one either.

I did an experiment with PowerDesigner and reverse-engineered a table
which have a load of table constraints. (As I mentioned, PD does not
support more than one table constraint per table.) And sure enough,
only one of the constraints made it into PD.

So, unless you can find some documentation that says that ERwin handles
multiple triggers on a table, my conclusion is that you have run into a
limitation of the tool, and the best suggestion for you would be to
use what even forum for enhancement requestions that CA provides.

--
Erland Sommarskog, SQL Server MVP, sommar@algonet. se

Books Online for SQL Server SP3 at

Microsoft SQL Server

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Get the flexibility you need to use integrated solutions, apps, and innovations in technology with your data, wherever it lives—in the cloud, on-premises, or at the edge.

**John Posada** · Jul 20 '05, 12:53 AM

Re: ERwin Triogger Bug

Thanks, I'm working on it.

John Posada

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

ERwin Triogger Bug

ERwin Triogger Bug

Comment

Comment

Comment