This was pretty much the only option when things were on premise but now that the cloud is such a focus, there was one tool I was particularly interested in:Ī tool for interacting with Microsoft SQL Server in Azure from my mac. ![]() I tried a handful of options including some open source cross platform tools, some paid cross platform tools and a mac only gem called SQLPRO for MSSQL. The free options were kinda 1990’s java ugly. One wouldn’t even connect, and one connected but I ran into problems enumerating fields. Of the paid options, the best bang for the buck for me was Hankinsoft’s SQLPro for MSSQL. SQLPro Studio is a multi-platform database client. SQLPro for MSSQL is a native Mac application with significant performance and a large feature set. All of these database clients accept local connections with MAMP (Mac, Windows) FREE. This tool is a native mac application (not a java port) and it shows: the app is fast, responsive, and looks like a mac app, supporting newer features such as the mac’s special full screen mode. It allows users to connect to multiple databases platforms including MySQL, PostgreSQL, Microsoft SQL. This version also works with iOS and Windows. The tool has code completion, the ability to drag and drop field and table names from the navigation pane on the left to the editor, some nice features like the ability to auto indent sql code, and the ability to run multiple queries (separated by semicolons ) and display the results from each one in the results window, just like MS SQL Management Studio does! I had no trouble connecting to PaaS SQL in Azure, and was able to do all the things I’d normally want to do. (There are versions for MySQL, SQLite, and Postgres, as well as a ‘studio’ version that supports multiple types of databases) SQLPro is a pretty stable product, and that’s no surprise, as the developer has been making database tools for quite some time now. ![]() SQLPro was $79.99 as of this writing – This is a one time, buy it, it’s yours price, and it’s very competitive vs other tools that also offer the ability to connect to and work with Microsoft SQL server. ![]() SQLPro Studio is the premium database management tool for Postgres, MySQL, Microsoft Management Studio and Oracle databases. So far I’m really enjoying being able to run queries against SQL in Azure natively on a mac – This is a great tool and highly recommended!Įnter your email address to subscribe to this blog and receive notifications of new posts by email. Some of the great features include: + Intellisense/SQL autocompletion. + Syntax highlighting with customizable themes (including dark). + Tabbed based interface for an optimal user experience. Payment will be charged to your iTunes Account at confirmation of purchase.+ Context aware database tree navigation, including quick access to tables, views, columns, indexes and much more + SQL Beautifier/formatter. Any unused portion of a free trial period, if offered, will be forfeited when the user purchases a subscription to that publication, where applicable. Subscriptions auto-renew within 24 hours of the expiration date unless auto-renewal is turned off in the iTunes account settings. Premium subscriptions are available as either a Monthly, or a Yearly duration. SQLPro offers Premium subscriptions (or a single Lifetime purchase) in order to interact with database result sets. SQLPro Studio supports the following database servers: + Master password support for additional security. + Context aware database tree navigation, including quick access to tables, views, columns, indexes and much more! ![]()
0 Comments
Leave a Reply. |