ERwin Triogger Bug

Jul 20, 2005

Hi, guys...new guy here. Let me introduce:

I'm a technical writer for B&N.com and I've been using ERwin
Datamodeler 4, release 4.1.2771 to create data dictionaries. I'm not a
DBA, though I'm slowly picking stuff up.

I discovered something yesterday that from my perspective is quite
serious and I wanted to verify that it is indeed an issue.

I have bunches of tables and for some tables, I have
triggers...anywhere 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...use
SQL Enterprise to script out the database, then perform a reverse
engineer on the script rather than the database, but that sucks.

Has anyone else noticed this?

John Posada

View 3 Replies


ADVERTISEMENT

ERWIN Vs VISIO 2000

Jun 21, 2000

Can anyone compared these two products for database design, documentation,... features, or know where I can find such info?

View 1 Replies View Related

Creating An Erwin Model Of DB

Apr 14, 2005

At work, we have a rather large VB project that uses MSSQL as the back end. This program was used to gather employee data and statistics. The author has since quit and I'm trying to add some functionality to the program. Unfortunately, there is no documentation on the db and there are about 80 tables. Is there any way to create a chart/Erwin Model of some sort that would show the primary keys/relationships between the tables?
Thanks!

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved