April 2, 2013 at 2:09 am
Hi,
We are having oracle 9i as database and migrating to sql server 2008.
Our oracle 9i database connects to another oracle databases and these databases are having different oracle version(9.2.0.8.0, 9.2.0.7.0,10.2.0.5.0,11.2.0.2.0,9.2.0.6.0,10.2.0.4.0,8.1.7.4.0 )
I do have two queries :
1) how to connect from Sql server 2008 R2 to different Oracle databases
2) How will other oracle databases connect to Sql server 2008 R2 database
April 4, 2013 at 1:24 pm
I can hopefully answer the first one. As long as you have the proper data provider installed on the server, you should be able to connect to any Oracle database you want (or DB2 or MySQL, etc.). You would install the provider, and then set up a Linked Server utilizing that driver to see data from an Oracle database.
The second question I cannot answer, I am not that familiar with Oracle and connections that it can make.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply