Re: Starting from scratch...

Agreed. The database will only be accessable via a newly designed web interface, so the back end will be completely redesigned. We don't really care about migrating the old schema...it has known issues that we will avoid.

Just inquiring about the satisfaction others have experienced with their choice of tool(s).

Darwin

Daniel Morgan <damorgan_at_exesolutions.com> wrote in message news:<3CC890FF.6CFB4B9D_at_exesolutions.com>...
> Darwin wrote:
>
> > Over the next year I will be creating a new (very complex) database
> > using Oracle 9i. I have old Sybase (500+ tables) to reference, but
> > have been told that I cannot move it to Oracle, it has to be
> > re-designed. I have not had the opportunity of starting green like
> > this and want to approach the task as efficiently as possible. We are
> > not worried at this point about loosing functionality, data will be
> > eventually ported over to the new database.
> >
> > I have been looking at development tools including Oracle's
> > Discoverer, Datanamic's DeZign (http://www.datanamic.com/), plus many
> > others. If you were starting from scratch and had the opportunity what
> > would you use?
> >
> > Thanks in advance...
> >
> > Darwin
>
> Any number of tools can migrate a schema though you will have to modify
> some things and you should recode the application.
>
> Look at ERwin, Visio Professional, etc.
>
> Daniel Morgan
Received on Fri Apr 26 2002 - 17:37:12 CEST