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

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!