Configuring Oracle SQL Developer for Microsoft SQL Server and MySQL

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:

Please share this post Share on Facebook5Share on Google+0Share on LinkedIn36Share on Reddit0Tweet about this on Twitter

Gokhan Atil is a database administrator who has hands-on experience with both RDBMS and noSQL databases (Oracle, PostgreSQL, Microsoft SQL Server, Sybase IQ, MySQL, Cassandra, MongoDB and ElasticSearch), and strong background on software development. He is certified as Oracle Certified Professional (OCP) and is awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for his continuous contributions to the Oracle users community.

34 Comments

  1. vijay

    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

    • Gokhan Atil

      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?

    • Eric

      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)?

    • Gokhan Atil

      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.

  2. Pingback: Oracle SQL Developer and jTDS Incompatibility | Gokhan Atil's Oracle Blog

  3. Uğur

    binlerce kez teşekkürler dostum.

    Work it sqldeveloper Version 3.2.20.09

  4. Pingback: Making the move to Mac at work | The Other Side of MyGeekDaddy

  5. Pingback: Making the move to Mac at work | MyGeekDaddy

  6. Maryjane Eldred

    I had to add the database name and domain=<domainname> to the port to get it to connect without errors; like this:

    1433/MSCRM;domain=MYDOMAIN

  7. Rommel

    Hi i have the same problen using JTDS 1.30 and SQL Developer Version 3.0.0.4 i supose that im using the lasted versión of JTDS. does any one knowk how to fix the problem?

    Tks. for the answers.

  8. abel

    Que cochinada de DEVELOPER, imposible ponerla a andar por más Java y jugetes que recomiendan en internet, Dios mio, que enredo – Renuncio a esta cochinada, buscaré una opcion amigable a microsoft

  9. jyoti

    It helped me to connect MySQL in SQL Developer .

    Thanks for this post 🙂

  10. Pingback: OSX Microsoft SQL Server Client | Outliers

  11. Pingback: Connect Microsoft Sql Server Using Oracle Sql Developer – Fighting Share

  12. Soudhanya

    I’m having the issue with connecting teradata jars. After I add the 3rd party driver from preference screen, I go to add new connection and i have not found Teradata tab . Could you please help me to fix this.

     

  13. Mohammed ALSarraj

    This is really helpfull.
    But how can I create a con with MS Access because there is no MS Access button con in SQL Developer, just Oracle button con.

    Thanks for your supporting

  14. prasad

    Not found the preference option in tools so not able to add third party JDBC driver. Trying this on mac. Please suggest.
    using Oracle Sql developer 17.2.
    Thanks,
    Prasad

Leave Comment

Your email address will not be published. Required fields are marked *