Based on answers on the OTN Forum and this post ( ) I finally got my new 4.x versions to work.įor SQL Developer 4.0EA3, I did as suggested in the article. Lots of folks, including me, have had issues getting the native Windows SSO connection to SQL Server to work. Check out this post by Jeff Smith for even more details. You can connect to other non-Oracle dbs as well. With this in place, you can now connect to SQL Server without having to load any other software. Open “Add Connection” – there should now be a SQL Server tab.In SQL Developer go to Tools -> Preferences -> Database -> Third party JDBC Drivers.Download and unzip the file into the main SQL Developer directory (or the directory of your choice).NOTE: For SQL Developer 4.0EA3 and SQL Developer Data Modeler 4.0 (production) you now need jtds-1.3.1. Hook up my FREE handy dandy Oracle SQL Developer to the SQL Server database.įirst you need to get the right driver.
Often this means looking at data and models in SQL Server as well as Oracle. I spend a lot of time reverse engineering client databases to see what kind of design they are working with or to simply create a data model diagram for them (so they know what they have).Īlong the way I often need to actually look at the data as well to do some analysis and profiling.
Tech Tip: Connect to SQL Server Using Oracle SQL Developer (updated)
0 kommentar(er)
