![]() ![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |