OraFAQ Forum: Networking and Gateways » Oracle 8i to SQL Server

Home » RDBMS Server » Networking and Gateways » Oracle 8i to SQL Server

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 8i to SQL Server [message #134745]

Fri, 26 August 2005 11:05

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

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

Mahesh Rajendran
Messages: 10708
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 01:40:53 CDT 2025