oracle 9i to Sql server 2008 R2 migration

• nitin.varshneya

  Old Hand

  Points: 347

  More actions

  April 2, 2013 at 2:09 am

  #291760

  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

• vikingDBA

  SSCertifiable

  Points: 5356

  More actions

  April 4, 2013 at 1:24 pm

  #1603718

  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.