Re: Migrating from Sybase

From: Arun Shastry <arun_at_accentsoftware.com>
Date: Thu, 25 Mar 1999 14:38:47 -0500
Message-ID: <36FA90C7.3CB7946E@accentsoftware.com>

I recently migrated a Sybase 11.0.3 system to Oracle 7.3.4. I used Oracle's gateway for Sybase...works like a charm. All you need to do is run a SQL from oracle to create a script that's something like 'create table <table_name> as select * from <table_name>@sybase'. Oracle takes care of the datatype conversions and such.

Good luck,
Arun

Paul Davies wrote:

> I'm currently about to embark on a migration of my application from Sybase
> to Oracle. Does anyone have any experiences of this process? Is it
> relatively straightforward? I have most of my code in Sybase stored
> procedures and need to rewrite then in PL/SQL. Does anyone have any feeling
> as to how different the languages are.
>
> Any feedback would be much appreciated.
>
> Thanks
>
> Paul
Received on Thu Mar 25 1999 - 13:38:47 CST