Most of DBAs I know, use TOAD for doing daily tasks, but I prefer Oracle SQL Developer. In my opinion, it has 3 important advantages against TOAD:
- It’s platform-independent: Although I use Windows on my laptop now, I’m a big fan of Linux and Solaris, and I don’t like being dependent on a specific OS. Thanks to Java, Oracle SQL Developer is platform-independent.
- It supports multiple databases: You can use SQL Developer for Microsoft Access, Microsoft SQL Server, MySQL, TimesTen, DB2 and (of course) Oracle.
- It’s extendible: Yes I know that there are not too much documents about it, but it’s extensible. For example, check FourthElephant’s extensions for SQL Developer: http://www.fourthelephant.com/sqldeveloper/download/
TOAD has a better interface because of using native Windows components but you can get used to SQL Developer if you spend time on it. Anyway, this blog has nothing to do with comparing SQL Developer and TOAD. I’ll just show how to configure SQL Developer to connect Microsoft SQL Server and MySQL.
You need to download and install the required (and supported) JDBC drivers to make Oracle SQL Developer connect MySQL and Microsoft SQL Server.
For MySQL download the J/connecter from http://www.mysql.com/products/connector/
For Microsoft SQL Server download the jTDS from http://sourceforge.net/projects/jtds/. The JDBC driver which is published by Microsoft doesn’t work with Oracle SQL Developer, at least I couldn’t make it work.
After you download the JDBC drivers, unzip them and then open prefences window in SQL Developer ( tools >> preferences ):
To add JDBC driver for Microsoft SQL Server, click “add entry…” button and find “jtds-1.2.5.jar” in the file open dialog.
To add JDBC driver for MySQL, click “add entry…” button and find “mysql-connector-java-5.1.17-bin.jar” in the file open dialog.
You need to restart SQL Developer to make these new JDBC drivers active. Then you can create a connections for Microsoft SQL Server, Sybase (because JDTS supports Sybase) and MySQL:
12 Responses to “Configuring Oracle SQL Developer for Microsoft SQL Server and MySQL”
Trackbacks/Pingbacks
- Oracle SQL Developer and jTDS Incompatibility | Gokhan Atil's Oracle Blog - [...] Developer. For more information about using SQL Developer with Ms SQL Server and MySQL, please read my related blog ...
Keep working ,great job!
Thanks for the tip! Works perfectly!
Great Info..
This is helpfull.. Thanks.
I have added an entry for MSQLSever(sybase)DB as shown. After restarting the sqldeveloper’s new connection window is not coming.
Could you please assist me…?
Thanks in advance.
Regards,
Vijay
Vijay,
Are you sure that you installed jTDS (not the official Microsoft jdbc driver) for MSSQL Server? After you restart, do you see the jar file in 3rd party drivers list?
I’m having the same issue. I’ve installed the jTDS 1.3.0 on a installation of SQL Developer running on Window Server 2003. After I add the 3rd party driver from preference screen, I go to add new connection and the New Connection window doesn’t open at all. If I remove the jTDS jar, it opens again. I have also restarted SQL Dev after adding jTDS. Any idea what I am doing wrong?
Another thing to note: when I do the same thing on a Windows 7 machine, it works. Could it be the OS (Server 2003)?
Eric and Vijay, I have tested the latest versions and I have similar problem. I think there’s an incompatibility problem about Java. I’ll let you know if I find a solution.
Dear friends, please check: http://www.gokhanatil.com/2012/11/oracle-sql-developer-and-jtds-incompatibility.html
Thanks a lot Gokhan. This worked for me.
Thanks a lot!
Works great with Versión 3.2.20.09 + jTDS 1.2.7
Greetings from Chile!
Thanks was helpful!
Thanks a lot
It was helpful.:)
Greetings from Iran!