Re: Starting from scratch...

I am considering Designer (my error with the Discoverer product) bundled with 9ias. From what I can tell that seems the most logical, since only data migration will occur.

Darwin

Daniel Morgan <damorgan_at_exesolutions.com> wrote in message news:<3CC96DC5.3F0B36F4_at_exesolutions.com>...
> Niall Litchfield wrote:
>
> > I don't think the OP wants to migrate a schema as such but design an app
> > from scratch. I can't give any real recommendations - cos i don't do this
> > task - but I'd have thought that designer rather than discoverer would be
> > the appropriate offering from Oracle themselves. The dev tools come bundled
> > with 9ias so I'd think very seriously about considering that platform as
> > well.
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > "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
> > >
>
> You are correct that it is Designer, not Discoverer. I interpreted that as a
> mistype. But the reference to an old Sybase schema made me think it was a
> migrataion. Perhaps a follow-up question will end the suspense.
>
> Daniel Morgan
Received on Tue May 07 2002 - 17:53:07 CEST