Re: migrating tables from Oracle to Sybase

In article <352B99A8.5B34678_at_imaginet.fr>, aptime_at_imaginet.fr says...
> 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.
>
>

If you've got Powerbuilder, look into the pipeline functions, they will copy whole tables, or selects from one database to another.

Jon Greisz
DB Microware, Inc.
jgg_at_dbmicro.com Received on Thu Apr 09 1998 - 00:00:00 CDT