Re: How to link Sybase SQL Anywhere to Oracle Server

Michael Thomadakis wrote in message <3478A4DB.7C73_at_cs.tamu.edu>...
> Do you know how to exchange Data between Sybase SQL Anywhere mobile
>database and Oracle Server? Do we need extra ODBC driver for that?

The simplest would be to unload the data from Sybase (does it have a bulk copy (bcp) program like SQL-Server?) and then load it into Oracle using SQL*Loader. Loading CSV files with SQL*Loader is pretty straight forward (we regulary load bcp data into Oracle).

Oracle has a gateway for SQL-Server. I'm not sure if it will work for Sybase or not. It may be worth a try as I know that Sybase drivers can be used to access SQL-Server. The reverse should be possible.

Another option is to use a client that supports heterogeneous SQL across different databases database (can be done in Delphi). Or you can develop a client to transfer data between the databases. With Delphi it's only 3 objects (2 table objects for destination and source and a batchmove object) with a single line of code...
:-)

regards,
Billy Received on Fri Nov 28 1997 - 00:00:00 CST