![]() ![]() I’m on a Mac, my company uses a SQL Server, and since there is not native SQL Server Enterprise manager client I was forced to find a workaround. Use Oracle’s FREE SQL Developer as a Microsoft SQL Server GUI on OSX Then you can create a connections for Microsoft SQL Server, Sybase (because JDTS supports Sybase) and MySQL: You need to restart SQL Developer to make these new JDBC drivers active. 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. To add JDBC driver for Microsoft SQL Server, click “add entry…” button and find “jtds-1.2.5.jar” in the file open dialog. The JDBC driver which is published by Microsoft doesn’t work with Oracle SQL Developer, at least I couldn’t make it work.Īfter you download the JDBC drivers, unzip them and then open prefences window in SQL Developer ( tools > preferences ): You need to download and install the required (and supported) JDBC drivers to make Oracle SQL Developer connect MySQL and Microsoft SQL Server.įor Microsoft SQL Server download the jTDS from. I’ll just show how to configure SQL Developer to connect Microsoft SQL Server and MySQL. Anyway, this blog has nothing to do with comparing SQL Developer and TOAD. 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. For example, check FourthElephant’s extensions for SQL Developer: It’s extendible: Yes I know that there are not too much documents about it, but it’s extensible.It supports multiple databases: You can use SQL Developer for Microsoft Access, Microsoft SQL Server, MySQL, TimesTen, DB2 and (of course) Oracle.Thanks to Java, Oracle SQL Developer is platform-independent. 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.In my opinion, it has 3 important advantages against TOAD: Most of DBAs I know, use TOAD for doing daily tasks, but I prefer Oracle SQL Developer. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |