Home » SQL & PL/SQL » Client Tools » No SQL Server option in Oracle SQL Developer (SQL Developer
No SQL Server option in Oracle SQL Developer [message #576098] Thu, 31 January 2013 07:54 Go to next message
Messages: 225
Registered: August 2008
Senior Member
Using SQL Developer I am able to login using oracle credentials but I dont see any option for SQL Server. I see both Oracle and Access. Why I am not able to see the SQL Server option in SQL Developer tool? I need the SQL Server option because I want to transfer some tables from SQL Server database to Oracle database.
Re: No SQL Server option in Oracle SQL Developer [message #576108 is a reply to message #576098] Thu, 31 January 2013 09:56 Go to previous message
Messages: 57
Registered: July 2009
Location: Raleigh, NC

You need to add and configure the jTDS driver to get connectivity for SQL Server and Sybase.

Instructions here:

It says to grab version 1.2, do it. If you get version 1.3 of the driver, it won't work.

Information about migration support in general can be found here

There's a dedicated page with examples, demos, etc for SQL Server migrations.
Previous Topic: Not extracting all of the data
Next Topic: export/import schemas
Goto Forum:

Current Time: Wed Nov 25 21:20:34 CST 2015

Total time taken to generate the page: 0.17433 seconds