Re: Oracle to Sybase Migration

If you are talking about just the data in an Oracle database, you can use ASE with its Component Integration Services. Starting with version 11.9.2 of ASE:

• define the server sp_addserver ORACLE, direct_connect, ORACLE go
• create database create database oradb <whatever size, devices> go sp_dboption oradb, 'select into', true go use oradb go checkpoint go
• create proxy tables create proxy_table t1 at 'ORACLE...t1' go create proxy_table t2 at 'ORACLE...t2'
• etc. etc. go
• copy data from Oracle to Sybase select * into local_t1 from t1 go select * into local_t2 from t2 go
• etc., etc.

It's generally that simple. You need ASE 11.9.2 and DirectConnect for Oracle. You can use ASE 11.5.x, but the 'create proxy_table' syntax is not supported in that release; you need to know all the column names and data types for each table, then:

sp_addobjectdef t1, 'ORACLE...t1'
go
create existing table t1
(

    c1 type1
    c2 type2
    ...
)
go

and so on.

Of course, this does not help with migration of your applications.

Regards,
Steve

Phil Houstoun wrote:

> G'day,
>
> Anybody got any advice, URLs, Perl or other scripts to ease a migration
> from Oracle to Sybase, especially export file munging? Viable
> alternatives include export->ERWin ddl file conversion or any way to get
> ERWin to suck in an Oracle export file. Oracle v6.0, ERWin 3.5, Sybase
> 11.9.2. Cheers.
>
> --
>
> Phil Houstoun
> Email: pjhoust_at_canada.com
> -----------------------------------------------------------------------
Received on Fri May 28 1999 - 01:58:33 CEST