A major plus over DBVis is that it does allow for importing of Excel files and it does a great job at it. Security features such as logins and roles is very straightforward as well. The visual query builder is nicely designed and better than DBVis. I hate this!! Does anyone really put tables in different schemas…hell no! Now the good, I love the interface for writing queries, stored procedures and triggers. My other complaint is that when navigating from server down to tables you must first navigate through the schemas to get to the tables. So basically, you have one window to explore items and another window where you do all your work. Meaning once you find the table you want to work with, double clicking it opens it in a new window. First the downside…I don’t like the fact its not a single window tool. So I sat out to find an easier query editor/writer. When a collegaue needed a recommendation for an easy to use tool to query data I didnt want to recommend DBVis mainly because he was a sql newbie. My other complaint is I don’t find the interface as smooth when writing queries, stored procedures or triggers. CSV import was a little clunky as it had a hard time understanding line breaks. Major downfall on importing is that it doesnt import from Excel format. It even allows for copying and pasting amongst many rows and columns and pasting data from excel. On the other hand, DBVis is a beast for quickly filtering data as well as editing. One of the things that attracted me to it was the fact it had a visual query designer just like Management Studio, but I quickly found the interface to not be as intuitive and a bit clunky. My first thoughts were this is the shit! The interface takes a little bit to get use to but it has some powerful features such as instant graphing based on query data. RazorSQL was first on my list but just didnt cut it. I sought out to find a Mac replacement for SQL Server Management Studio. After declaring war against Windows and anything about it.

Sql razorsql mac