I am trying to test some migration from SQL Server to Oracle. I went through the sample tutorial but I cannot find the SQL Server tab during connection creation.
I can only see Oracle and Access tabs.
Can some one help me to sort out this issue.
Hi Shaamil -
You need to add the JDBC driver for SQL Server.
Help->Check for Updates...
Make sure "Third Party SQL Developer Extensions" is checked on the Source page
Select "JTDS JDBC Driver" on Updates page
after install, the tab will be there
SQL Developer Team
<p>Yes, you need to add the drivers to support the SQL Server connections. In the Release Notes, there is a link to the <a hrref="Migrations%20Getting%20Started%20document|http://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html%20">Migrations Getting Started document</a>. That shows you where to get the drivers and how to add them. The document continues by showing you how to use the migration feature (this section is related to SQL Developer 2.0 as the functionality has changed considerably for 3.0). Adding the drivers is the same for both versions.</p>
Thank you for the feedback.
I am using SQL developer in a isolated environment where as all download need to make request and downloaded according to my company IP policy compliences. Is there any link where I can download and get it activated. if so can you please provide me with the link and the seting up procedurefor 3rd party activation. I am using SQL Developer on XP Professional 32 bit.
Edited by: Shaamil . on Nov 24, 2010 2:18 PM
for SQL Server you will need the JTDS JDBC driver, you can download the driver from here:
the supported JTDS version for SQL Developer is not the latest one but the following:
when you have the driver downloaded you can add it as a third party JDBC driver and then you will be able to conenct.
if you need to enable a link in your proxy I'd suggest you use the first one so you will be able to download updated drivers if needed.
Please review the Migrations Getting Started (http://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html) document. There is a link to this document from the downloads page and in the release notes. The detail provided by other users on this forum are correct, but it is important to review the release notes for general queries when you start working with new products.
Thank you for specifying that the latest version does not work. No where on the web does anyone say this. I've been going around in circles trying to figure out what was wrong. I downloaded the 1.2.2 version and all is good now!
Actually, look at the following link (and find the Microsoft SQL Server and Sybase: jTDS driver available... section):
You can get there by drilling down from one of this forum's top level announcement links as follows:
1. SQL Developer 3.2.2 Patch Available Now
2. Release Notes -> see Third Party Databases
4. Getting Started -> Oracle SQL Developer Migrations -> Configuring JDBC drivers
Also, a general web search on SQL Developer jTDS driver came up with a blog listing a 1.2.7 jTDS driver solution as the second hit.