Home » RDBMS Server » Networking and Gateways » oracle 9i to Sql server 2008 R2 migration (oracle 9i)
oracle 9i to Sql server 2008 R2 migration [message #581099] Tue, 02 April 2013 03:15 Go to next message
nivarshn
Messages: 1
Registered: December 2012
Location: INDIA
Junior Member
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

Re: oracle 9i to Sql server 2008 R2 migration [message #581100 is a reply to message #581099] Tue, 02 April 2013 03:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) Ask this on a MS SQL server forum
2) Using HS (Heterogeneous Gateway), an Oracle option you have to buy.

Regards
Michel
Re: oracle 9i to Sql server 2008 R2 migration [message #583562 is a reply to message #581100] Wed, 01 May 2013 16:02 Go to previous message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
The other way around connecting SQL Server 2008 R2 to Oracle might work from 10g on (depending on the installed oracle client).
Previous Topic: OracleOraDB11g_home1TNSListener Service
Next Topic: ORA-12154: TNS:could not resolve service name
Goto Forum:
  


Current Time: Thu Mar 28 12:30:29 CDT 2024