Re: What does SQLDeveloper change?

From: Niall Litchfield <>
Date: Fri, 20 Apr 2018 22:12:00 +0100
Message-ID: <> is Microsoft's .net provider for Oracle. It's complaining that it can't find appropriate Oracle Client libraries. If you are setting ORACLE_HOME or similar that might cause that error. I know next to nothing about SSMA, but there is an Oracle supplied .net set of libraries that support Oracle much, much better than the MS ones did.

On Fri, Apr 20, 2018 at 12:52 AM, Dave Herring <> wrote:

> I've got some sort of conflict between SQL Server SSMA conversion tool and
> SQL Developer and I can't figure out where it is.
> I'm in the process of generating assessment reports for the conversion of
> around 130 databases and on a positive piece of this I've learned enough
> powershell to script this. Each assessment is taking anywhere from 1/2 hr
> to 2 hrs so I figured I'd grab the latest version of SQL Developer (18.2).
> After getting SQL Developer to work I noticed that every SSMA execution
> failed, giving the error: "NESTED System.Data.OracleClient requires Oracle
> client software version 8.1.7 or greater.". The problem is I can't figure
> out what the SQL Developer setup changed as all I did was unzip the
> download under "C:\Oracle" and then start the executable to validate it was
> working.
> I removed "C:\Oracle\sqldeveloper", along with
> %AppData\Roaming\sqldeveloper directories but the problem persists. My
> guess is there's some sort of java-related change that happened or 32-bit
> vs. 64-bit dll change but I can't figure it out. Anyone know all changes
> that SQLDeveloper makes?
> --
> Dave

Niall Litchfield
Oracle DBA

Received on Fri Apr 20 2018 - 23:12:00 CEST

Original text of this message