Having chosen Oracle SQL Developer as your preferred Oracle database tool, do you have to install and learn a new technology for supporting your MS SQL databases? It’s easy to connect SQL Developer to Software developer jobs in chennai SQL databases, and I’ll show you how. For years I worked in technical support for software vendors, and I never knew what client tool would be available when I accessed a customer system.
Did not find what they wanted? Try here
In fact, in many cases they’d only give me command-line SQLPlus access. Consequently I never really chose a preferred Oracle client, nor became particularly proficient with anything other than command-line SQLPlus. Eventually I found myself working directly with a client, and could finally choose whichever tool I liked best, and like many of you I chose Raptor – now known as Oracle SQL Developer. Explaining my choice is outside the scope of this article, but suffice it to say that it’s a powerful time-saver at best, and a big step up on command-line SQLPLus at worst. Not all the database applications we support are going to be Oracle-based, and the most popular of the alternatives is Sybase’s curious nephew MS-SQL.
Fortunately there’s no need to find another application for your MS-SQL instances, you can still use SQL Developer, and here’s how. If you don’t already have one, download a JDBC driver for MS-SQL. I use the jTDS driver, which is open-source Java. It doesn’t matter where you place it, but remember where. As explained in Oracle’s tutorial, under Preferences, scroll down to Database and Third Party JDBC Drivers. Now you can create a new MS SQL database connection the same you would an Oracle connection.
If you don’t see that tab, then something went wrong – either you got the wrong jar file or it didn’t load correctly. If you’re brand new to Oracle SQL Developer, Anders Andreasen has an example with a few extra screenshots. Use the Test button to make sure you can connect, and if you can’t the error message ought to be descriptive enough to give you a starting point to troubleshoot. Needless to say, technologies as complex as these will occasionally present you with unexpected difficulties. For instance, you may find that you need to copy the ntlmauth. IP communication enabled, and over default port 1433. If you used the driver I recommended, they have a FAQ that can help you track down some types of errors.
If you support multiple databases, there may not be a need to install multiple tools. Oracle SQL Developer can be used to connect to different flavours of databases, including MS SQL. Just download and load in the JDBC driver, and you should be able to create a new database connection as easily as you can with Oracle. Some of the stuff up there is very relevant and useful keep it up. Thanks for adding your comment, I’ve been looking for hours on why I couldn’t connect, and this solved it for me. I’m going to start using that instead the outdated enterprise manager.