--
Anne Buhl
Director, Chapter Coordination
Mothers & More
"Luch" <optimaljedi_at_nospam.net> wrote in message
news:oGfj7.5184$Fv3.435737_at_newsread2.prod.itd.earthlink.net...
> I need to have a routine to transfer records from a DB that is a SQL
Server
> to our Oracle DB. I've done this before with databases that were both
Oracle
> DBs using a database link. I wanted to know if it was possible to do this
> ( a database link) with an Oracle & SQL Server DB.
>
> And if so, to have a trigger on the SQL Server database call an Oracle
> stored procedure, and vice versa. Or if it's simply more practical to have
> an actual application development tool (we use Powerbuilder) to connect to
> both databases and do the work, and forget the whole database link idea
> between oracle & SQL server. Any thoughts?
>
You certainly can have an application such as PB perform the work but then
you either have to enforce the 2 phase commit model or handle a situation
when one of the servers is not online buy coding this all yourself, which
can become a headache. We do it this way and it's problematic.
Oracle has gateway products that allow you to execute procs and do DML in
MSSQL. I don't know about vice versa.
Sybase's replication server has the capability to manage the situation by
replicating data from oracle to MSSQL as well as vice versa, including
stored procedure execution.
jab
Received on Thu Aug 30 2001 - 21:42:33 CDT
