Sybase Database - Two databases oracle and sybase

Author

Two databases oracle and sybase

jill

2006-04-04, 8:23 pm

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.

DA Morgan

2006-04-04, 8:23 pm

jill wrote:
> 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.

Depends on the quantity of data, the available window to move the data,
and a number of other factors. Have you looked at the migration tools
Oracle provides?

http://www.oracle.com/technology/te...n/kb/index.html
http://download-west.oracle.com/doc...h1.htm#sthref12
http://www.oracle.com/technology/do...n/gateways.html

It might be most efficient to dump the data as a fixed-length or
delimited ASCII file and load it with Oracle's SQL*Loader.

Contact me off-line if you wish.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

jill

2006-04-04, 8:23 pm

oracle Gateway our database team is looking into it. Our database team
suggested to look into java two datasources. That what I have started
looking into.

I want to know, using two connection objects in java is better or
oracle gateway. And if any body used oracle gateway what are the pros
and cons.

For this current project, data is not huge. But for our company in
other projects we may have huge data, transaction management issues
etc.

Thanks for your help.

DA Morgan

2006-04-04, 8:23 pm

jill wrote:
> oracle Gateway our database team is looking into it. Our database team
> suggested to look into java two datasources. That what I have started
> looking into.
>
> I want to know, using two connection objects in java is better or
> oracle gateway. And if any body used oracle gateway what are the pros
> and cons.
>
> For this current project, data is not huge. But for our company in
> other projects we may have huge data, transaction management issues
> etc.
>
> Thanks for your help.

The GateWay is better as it will handle all of the various data types
and their translation among other possible issues.

But depending on how much data ... dumping it might be a lot faster.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

Sponsored Links