Re: Heterogeneous Replication
- From: Michael Thomas <mhthomas@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 29 Jan 2004 18:06:28 -0800 (PST)
Hi,
We(I) configured ~20 ODBC connections using Oracle
Generic Heterogeneous Services (HS). I hated it
because we were dynamically adding-dropping
connections every couple weeks, which is a manual
configuration process on the server (updating config
files, processes, etc).
I found Generic HS had syntax incompatibilities that
hung cursors on DB_LINKS based on incompatible SQL
statements (which I had to protect using views). At
one point I figured out a couple tricks to flush the
DB_LINK connection and recover cursors, but I forgot
them now.
We ended up using an ETL tool instead to bridge
databases, and I think Oracle's gateway products might
also be something to check out. Maybe others had
better luck with a particular flavor of HS, but not
Generic.
That's my opinion. Good luck.
Regards,
Mike Thomas
--- Nikhil Khimani <nkhimani@xxxxxxxxxxxxxxx> wrote:
> L&G,
>
> We are looking at replicating data from Oracle
> (8.1.7.0 and 9.2.0.4) to
> MS-SQL (2K). I would like to know if anyone has done
> this using
> heterogeneous services and if yes would you please
> get me started at least
> with the right links to RTFM. Anything additional
> will be gravy. We are also
> looking at Golden Gate solutions (for Oracle to
> MS-SQL) and I'd appreciate a
> feed-back, if anyone has had any experience with it.
>
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
