Click here to Skip to main content
14,387,205 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hi All,

Currently am working for migration from oracle 11g to SQL server 2012, and after googling we found that SSMA (SQL server migration assistant) tool is available with more flexibility for migration.

Now am trying to do it my local with dev environment.I have oracle in dev server and sql server in another dev server.I installed SSMA in my machine and trying to connect Sql server and oracle.

SSMA able to connect Sql server from my machine but when I try to connect Oracle am seeing below error
Connection to Oracle failed.
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.


I searched in the google for this issue and saying install oracle client and ODAC.

My concern here is do I need to install Oracle on Dev server of MS Sql server? if this is the case,how to proceed in Production?

Could you please suggest

What I have tried:

I have tried to install ODAC from Oracle.
Posted
Updated 7-Mar-16 3:21am
Comments
Mehdi Gholam 7-Mar-16 6:55am
   
For migration to work you only need one machine to read from Oracle, so install the drivers on that machine.
Rate this:
Please Sign up or sign in to vote.

Solution 2

You have to do exactly what the error message says. On your workstation where you're using SSMA, you must install a version of the Oracle Client software greater than version 8.1.7. In the case of an oracle 11 server, you have to install Oracle Client 10 or greater.
   
Comments
pratap420 7-Mar-16 12:00pm
   
Here client means Oracle software? or any driver?
Dave Kreskowiak 7-Mar-16 13:05pm
   
It's the CLIENT. Oracle Database 11g Release 2 for Microsoft Windows (32-bit)[^].

The client is the second link down, where it says 684,581,290 bytes.
pratap420 15-Mar-16 5:22am
   
thank you for your support...Now its working
Rate this:
Please Sign up or sign in to vote.

Solution 1

Download and install Oracle Data Provider for .net[^].
Then you'll be able to connect to oracle database.
   
Comments
pratap420 7-Mar-16 12:10pm
   
Thanks for your suggestion.Could you please clarify,data provider should I install in my machine or Oracle dev box or sql server dev box?
Maciej Los 7-Mar-16 12:45pm
   
Client machine
pratap420 15-Mar-16 5:22am
   
thank you for your support...Now its working
Maciej Los 15-Mar-16 16:44pm
   
You're very welcome. Can you accept this answer as a solution - formally, to remove your question from unanswered list?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100