Help - Search - Members - Calendar
Full Version: Linking a SQL Server database to an Oracle db
Oracle DBA Forums > Oracle > Oracle Forum
sredden1
I found a link to a topic concerning this issue (click here), but the question mentions that the poster was looking for a "band-aid" fix... I was just wondering if this method will work for a more long-term solution, or if something additional/something else completely would need to be done.

Any help would be appreciated.

Thanks
burleson
Hi Mr. Redden,

>> I was just wondering if this method will work for a more long-term solution, or if something additional/something else completely would need to be done.

Great question!

There are many "permanent" ways to cross-talk between MS-SQL and Oracle:

*******************************************

- Goldengate replication: Expensive, and complex to configure, but top-notch. It called the bridge to everywhere:

http://www.dba-oracle.com/t_karam_ioug_sel...engate_0411.htm



Goldengate also allows n-way replication so that you can replicate in both directions:

http://www.rampant-books.com/art_porus_goldengate.htm

- Oracle hetrogeneous services: Cheap and easy, see complete details here:

http://www.dba-oracle.com/t_heterogeneous_..._sql_server.htm

The choice for you is always "it depends"!

You can rent a DBA to assist you for a few hours in the best tool and how to set it up, it will save you much grief:

http://www.dba-oracle.com/Oracle_replication.htm

Good Luck!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.