Re: How to connect from sybase to oracle
- From: Jurijs Velikanovs <j.velikanovs@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Wed, 3 Jun 2009 20:38:20 +1000
Hi,
I believe the answer depends on your requirements:
A. Oracle Gateway - separately licensed product (read expensive
solution). Isn't used often (read a lot of bugs). Might not support
your platform. In spite of disadvantages it is IMHO the only solution
that is transparent. You select data via DB link as you are working
with other remote Oracle DB.
B. Write a small Java program that would read data from Oracle and
Send it to Sybase (connects to DB-s via JDBC drivers). Cheap and
simple.
C. Transfer data via text files.
...
Just my 0.02$,
Yury
On Wed, Jun 3, 2009 at 6:00 PM, Ramakrishnan Seshadhri
<ramakrishnan42@xxxxxxxxx> wrote:
> Hi,
>
> Is there a possibility to connect to Sybase DB from Oracle. Currently My
> Oracle DB is 10gR2 and resides on a Linux server and the sybase db is on a
> windows server. Is it feasible to coonct to Sysbase from Oracle and pull
> data from tables.
>
>
> Ramakrishnan.S
>
--
Jurijs
+371 29268222 (+2 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
Other related posts:
