Home » RDBMS Server » Networking and Gateways » Oracle 8i to SQL Server
Oracle 8i to SQL Server [message #134745] Fri, 26 August 2005 11:05 Go to next message
jesilva
Messages: 1
Registered: August 2005
Location: Houston, Tx
Junior Member
Is it possible to have an trigger in Oracle populate data from the Oracle database to a table in SQL Server?

Report message to a moderator

Re: Oracle 8i to SQL Server [message #134950 is a reply to message #134745] Mon, 29 August 2005 03:15 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Might be. Haven't tried though... but logic should be:

within trigger call command prompt & execute sql server data loader, "osql" i believe...

Pls Give it a try & let us know the result...

Regds
Girish

Report message to a moderator

Re: Oracle 8i to SQL Server [message #135008 is a reply to message #134950] Mon, 29 August 2005 07:11 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is called a 'linked server' in Microsoft terms.

http://www.microsoft.com/sql/techinfo/tips/administration/addingoracle.mspx
http://www.informit.com/articles/article.asp?p=360063&seqNum=2&rl=1

Forgive my ignorance, I am not into Microsoft technologies.
The above link should help you.
In oracle, look into heterogenous services / Distributed databases (8i term).

Report message to a moderator

Previous Topic: Listener doesn't start (Oracle 9.2.0.5, Solaris 9)
Next Topic: network adapter failed to establish connection
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 04:01:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.