Re: conv. Sybase -> Oracle

You should also contact Oracle Design & Migration Services. Free conversion kits are available, including Sybase -> Oracle. Visit http://technet.oracle.com and register free of charge for more information on Oracle resources.

Feel free to contact me for additional info.

Chris Weiss wrote:

> With some creative SQL you should be able to generated the DDL for your
> tables and views.
>
> The data from your table could be transferred with any tool that supports
> multiple database connections such as Delphi, MS Access using linked ODBC
> tables, etc. If you have no other tools, build SQL from SQL into a spool
> file that you can run on Oracle. I know that ISQL for Sybase can pipe its
> output to a file.
>
> You shouldn't be able to directly convert procedures and triggers because
> Oracle uses PL/SQL while Sybase uses Transact SQL. I don't know of tools
> that do this.
>
> If you are looking for a more a automatic process try a tool like Erwin.
> You can begin by selecting "reverse engineer database" on your Sybase
> schema. At the very least, your tables, views, foreign keys, etc. should
> come across. Some tools might even preserve your triggers. After reverse
> engineering your Sybase database, you should be able to switch and rebuild
> your schema in Oracle. You will still have to transfer the data in an
> outside process.
>
> Christopher Weiss
> Professional Services Staff
> Compuware Corporation
>
> W.Vorwerk wrote in message <374177E8.C3070A83_at_t-online.de>...
> >Does anyone know if there are programs, procedured etc. to
> >convert Sybase db-objects in Oracle db-objects (procedures,
> >trigger, views, tables) ?
> >
> >Thanks,
> >
> >Wolfgang

Received on Wed May 19 1999 - 20:17:08 CDT