Re: Migration Sybase to Oracle

I agree with Chris Weiss.

Some tools can help migration. Visit http://technet.oracle.com (free sign up) and search migration toolkits from Oracle Data & Migration Services.

Regards

Chris Weiss 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
> >

Received on Tue Jul 27 1999 - 13:58:20 CDT