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?
--
Luch
replace nospam with usa for e-mail.
Received on Wed Aug 29 2001 - 19:21:40 CDT
