Re: Migration Sybase to Oracle

From: Chris Weiss <weisschr_at_pilot.msu.edu>
Date: Tue, 27 Jul 1999 12:52:47 -0400
Message-ID: <7nko5o$2jm$1@msunews.cl.msu.edu>

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 - 11:52:47 CDT