Another way to do this is to FE the model to a sql script, add the
columns in the sql script to all tables, and then do a complete
compare of the original model against the sql script. Another
inelegant solution. This is good for audit type fields because they
tend to be physical only.
-Steve
--- In ERWin-DB-Modeling@xxxxxxxxxxxxxxx, datamodel@... wrote:
>
> I've done this for "audit"-type columns (date_inserted,
update_user_id, etc.) by creating an non-generating table with these
columns, all as PK columns, then adding non-generating FK
relationships to this "parent" table from all the tables I needed to
add the columns to. The columns are then all inherited in each
table. Certainly not elegant, but workable. More details on request.
>
> Bill L
>
> -----Original Message-----
> From: PristineData <lists@...>
> To: ERWin-DB-Modeling@xxxxxxxxxxxxxxx
> Sent: Mon, 13 Mar 2006 11:29:21 -0800 (PST)
> Subject: [ERWin-DB-Modeling] Find/Replace
>
>
>
> Does ERwin have a global find/Replace option for a data model.
> Here is the scenario: I inherited physical models from my
predecessor, I
> have to now add 3 standard columns to all the tables within the
model.
> Is there an option that I can use to achieve this besides adding
these
> columns manually to every table?
>
>
> --
> View this message in context: http://www.nabble.com/Find-Replace-
t1274442.html#a3383969
> Sent from the ERWin forum at Nabble.com.
>
>
>
>
>
> To subscribe, send an email to:
> ERWin-DB-Modeling-subscribe@xxxxxxxxxxxxxxx
>
> To unsubscribe, send an email to:
> ERWin-DB-Modeling-unsubscribe@xxxxxxxxxxxxxxx
>
> Archives: http://groups.yahoo.com/group/ERWin-DB-Modeling/messages
> Yahoo! Groups Links
>
To subscribe, send an email to:
ERWin-DB-Modeling-subscribe@xxxxxxxxxxxxxxx
To unsubscribe, send an email to:
ERWin-DB-Modeling-unsubscribe@xxxxxxxxxxxxxxx
Archives: http://groups.yahoo.com/group/ERWin-DB-Modeling/messages
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ERWin-DB-Modeling/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ERWin-DB-Modeling/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:ERWin-DB-Modeling-digest@xxxxxxxxxxxxxxx
mailto:ERWin-DB-Modeling-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
ERWin-DB-Modeling-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|
