How To Connect Oracle DB with Microsoft SQL Server

Hello,
Does anyone know how to connect Oracle 10g DB to Microsoft SQL Server? If so, any tips or help would be greatly appreciated!
Thanks!I'm not sure which side you're connecting from (from mssql to oracle or vice versa), but a good starting point would be to look up linked servers in books online. MSHelp has a pretty good troubleshooter at http://support.microsoft.com/kb/280106/ .

Good luck.|||Hello,

Does anyone know how to connect Oracle 10g DB to Microsoft SQL Server? If so, any tips or help would be greatly appreciated!

Thanks!

Things that I have done/would do in your place (not saying that they are right):

1. Install Oracle 10g Client s/w on db server
2. Create tnsnames entry(ies) using Oracle Net Manager

Then, optionally:
3a. Create a linked server and access Oracle through OPENQUERY and/or four-part naming convention
3b. Create DTS package(s) to move data local to SQL Database

Which path you choose (a or b) depends on your requirements and resources.

Regards,

hmscottsql

How to compare table from SQLSERVER 2005 with oracle

Hi,

i am trying to compare the table which is existing in SQL server2005 with the same in oracle 10g. is there any short cut procedure for it..?

Sreenivas

What do you want to compare the schema of the data ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||i want to compare the table structure including the datatypes of some xxx table in sql server with oracle table which is having the same name and structure..these two are located in different databases and different locations with different schema names..|||

I have a script for SQL Server which does the things on two different SQL Server databases. For Oracle you would have to do a comparison betwen the datatype which can differ although they are in common the same. Just write me a mail if you want to have this script.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Jen,

Could u mail me the script for SQL server comparison..i dont have any script for oracle ...

I am trying to reach you at your mail id. but surprisely it bounce back to me..