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).
|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)|