I work on a Mac and in a bandwidth rich environment, such as my work network, I usually connect to SQL Server via a MSSQL client running on a terminal server which I access over RDP. I like the GUI with the added intelliSense features from RedGate tools, plus the OSX RDP Client by Microsoft works great.
While traveling, I prefer to have access to a low bandwidth solution. I started investigating and playing with a few OSX MSSQL clients available.
I tried all the tools listed here including a DB Visualizer plugin for eclipse. In my analysis I factored in cost and feature set as well as Mean time to annoyance (MTTA).
Tool | Cost | MTTA |
SQLPro for MSSQL | >$0.00 | Unknown |
SQuirrel SQL (free, open source) | Free Open Source | Immediate (Not so intuitive) |
DB Visualizer | Freemium | Tolerable up to a day |
SQL Workbench/J (free, open source) | Free Open Source | Immediate (Not so intuitive) |
Oracle SQL Developer (free) | Free Not Open Source | Still Using |
TOAD For MAC | Free | Immediate (No MSSQL Support on OSX) |
My recommendation is to use the free Oracle SQL Developer with this instructions for setting up the MSSQL JTDS driver. This tool gets the job done!