Re: Migration Sybase to Oracle

From: <canglin_at_anglingroup.com>
Date: Wed, 04 Aug 1999 18:05:38 GMT
Message-ID: <7o9vda$oh3$1@nnrp1.deja.com>

I too am tasked with doing this type of conversion. Can you provide us with some concrete numbers? I am thinking about number of procedures, experience of developer(s) doing conversion and length of time to convert. I would also like to get information on your subjective rating on the number of easy, medium and hard procedures to convert. Any gotchas would be appreciated as well.

Thanks

In article <7nko5o$2jm$1_at_msunews.cl.msu.edu>, "Chris Weiss" <weisschr_at_pilot.msu.edu> wrote:
> I work in both Sybase and Oracle, and there is nothing that converts
> procedure directly without significant re-programming, unless your
code is
> trivial. T-SQL and PL/SQL behave differently and have significantly
> different syntax with respect to variables, data types and
methodologies.
>
> Plan on doing a significant amount of re-writing of your T-SQL.
>
> On the bright side of things....
>
> PL/SQL is a much more powerful language than Transact SQL. Oracle 8i
adds
> every feature from Sybase I would have wanted to see in Oracle, making
> Oracle 8i overwhelmingly better than Sybase. Even if you aren't using
> Oracle 8i's bells and whistles, you will still find it to be far
superior to
> Transact SQL in most things.
>
> Good Luck,
> Christopher Weiss
> Professional Services Division
> Compuware Corporation
>
> Udo Ottink <U.Ottink_at_mssys.com> wrote in message
> news:379DBEA6.12A37118_at_mssys.com...
> > Hi,
> >
> > are there any tools that helps us converting T-SQL-Procedures into
> > PL-SQL-Procedures.
> >
> > So long
> > Udo
> >
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 04 1999 - 13:05:38 CDT