Re: migrating tables from Oracle to Sybase

With ASE version 11.5, you could define the Oracle tables as 'proxy' objects in Sybase, then do the equivalent of 'select * into local_table from oracle_table.

This would be the quickest way to get it done.

You need ASE 11.5 (or greater), plus DirectConnect/Oracle 11.0, to do this.

A tool comes with ASE 11.5 called defgen, which extracts all the metadata from Oracle for you, and generates the SQL needed to define the 'proxy' objects in ASE.

ASE: Adaptive Server/Enterprise, formerly known as Sybase SQL Server.

Regards,
Steve
Sybase engineering

aptime wrote:

> Hi folks
>
> I'd like to migrate data from Oracle 7.3 to Sybase System 11.
> Does anyone know what tool would be the most accurate ?
>
> I've tried "bcp" (Sybase), "Infomaker" (Powersoft/Sybase), "defncopy"
> (Sybase),
> and "Data Manager" (Oracle), but so far I have not succeeded.
> Maybe I don't use these tools the proper way. Usually I've got ODBC
> errors, or
> file formats that are not recognised by one of the 2 DBMS.
>
> Thanks for help.
Received on Wed Apr 08 1998 - 00:00:00 CDT