Re: Database link to a SQL Server possible?

"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?

I have done something simaler in the past. We used sybase open server running on solaris to act as a bridge between sql server and oracle. The open server appeared to the SQL server box as another SQL server, so we could then create a linked server in sql server pointing to the solaris box which then connected to the oracle server and ran the code necessary.

If the transfer only needs to be done periodically rather than real time, you can install oracle networking software on the SQL server machine and then create a DTS package to transfer the data.

Anthony Received on Fri Aug 31 2001 - 05:51:25 CDT