|The splash screen for Squirrel SQL|
I'm working on a project that draws from a Microsoft Sql Database. Unfortunately there is no project documentation which means that it takes longer to become familiar with the design. I particularly wanted an ERD of the database but this wasn't available. So I looked for open source reverse engineering tools and found Squirrel SQL. This is a very handy tool as it supports a variety of databases and client operating systems.
Installing the Microsoft JDBC (available from the Microsoft site) was a snap:
- Just download the archive, extract it somewhere meaningful (I put mine as a directory in Squirrel).
- Edit the Microsoft SQL driver in your driver list
- Add an extra class and point it to the JDBC4 jar file (version 4 is required for newer versions of the JDK)
- The driver should load now