Two database - sybase and oracle

From: jill <jilljuneja_at_gmail.com>
Date: 4 Apr 2006 12:32:05 -0700
Message-ID: <1144179125.010661.177820@u72g2000cwu.googlegroups.com>

Hi All,

Our company is in phase of moving from Sybase to oracle, which is very long process.

Currently in our application, heart of our data is in Sybase and some new tables are in oracle.

We have two options right now.

Use oracle gateway (we are new to it)
Or use Java two data sources or connection object for oracle and Sybase. We do not have issue of transaction management across two databases currently, so we could go path of java 2 data sources.

Could any body suggest me pros and cons of using two data sources or going in direction of oracle gateway.

Thanks and Regards,
Vandana. Received on Tue Apr 04 2006 - 14:32:05 CDT