How to query an oracle data from SQL server Query analyser

Hi ,

I am having 2 data store .

1. Oracle 10g

2 SQL server 2000

My requirement is that , i need to insert some data from sql server database table to oracle database using sql server query analyser or interface.

If there is any way ,plz let me know it

Thanks

Abraham

You should be able to setup a linkserver in Sql server to Oracle and access Oracle data. Follow this link and this.|||

Hi sankar,

I am trying that option, if that works out how we can insert data or query data from oracle , is that the normal SQL way or some other format is there.

basically i need to write a Sql server trigger on a table which will insert data to oracle based on the new records insertion in sql server.

Thanks

Abraham

|||

I am not sure if that is good idea to wrap this inside a trigger. Though linked servers provide good access to data from different data sources, it comes with some issues. May be you need to be aware of what you getting in to. Check out some these links and read some more.

http://www.thescripts.com/forum/thread80168.html

http://support.microsoft.com/default.aspx?scid=kb;en-us;191168&Product=sql2k

http://support.microsoft.com/kb/306212