Re: Erwin reverse engineering question
Date: Tue, 13 Nov 2001 16:38:41 +0100
Message-ID: <9sreta$ibo$1_at_newshost.accu.uu.nl>
"Steve Jones" <steve_at_jones.com> wrote in message
news:3bf01f65$0$8506$cc9e4d1f_at_news.dial.pipex.com...
> "Jerry Gitomer" <jgitomer_at_erols.com> wrote in message
> news:9snkqq$ksc$1_at_bob.news.rcn.net...
> > Tim Mueller wrote:
> >
> > You are best off biting the bullet and renaming the columns.
> > To minimize hardship on your developers prepare a cross
> > reference for them with old names and new names.
> >
> >
> > --
> > Jerry Gitomer
> > Once I learned how to spell DBA, I became one
>
> I believe you can define synonyms in Oracle, for the old names, so the
> Developers can still use their names without having to change anything.
If you want something more than just new names for tables you can use views,
and they are also supported in more databases than only Oracle. Althoug the
implementation
efficiency of views differs in the various database products, how well they
can optimize away the views, and allow updates on views.
Willem Received on Tue Nov 13 2001 - 16:38:41 CET