
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. 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. (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 STUDIO ADD USER CODE
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! With SQLPro you can work simultaneously with Oracle. SQLPro allows you to connect directly to most popular database servers using the single interface so that you can make your work faster and more efficient. + Tabbed based interface for an optimal user experience. + Syntax highlighting with customizable themes (including dark). Some of the great features include: + Intellisense/SQL autocompletion. I had no trouble connecting to PaaS SQL in Azure, and was able to do all the things I’d normally want to do. SQLPro Studio is a powerful, easy-to-use tool for designing complex database structures and managing your data. SQLPro SQL Editor and SQL client is a visual database management and development tool for multiple databases with Explorer interface. SQLPro Studio is the premium database management tool for Postgres, MySQL, Microsoft Management Studio and Oracle databases.

SQLPRO STUDIO ADD USER FULL
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. Of the paid options, the best bang for the buck for me was Hankinsoft’s SQLPro for MSSQL. One wouldn’t even connect, and one connected but I ran into problems enumerating fields. The free options were kinda 1990’s java ugly. 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. 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. A simple, powerful database manager for macOS, iOS and Windows Multiple database support Best at the basics Intuitive interface Cloud support Multiple. In the past, I’ve almost always remoted into windows machines to get work done – SharePoint, Powershell, SQL Management Studio, etc.
SQLPRO STUDIO ADD USER PROFESSIONAL
While most of this blog covers my professional experience with SharePoint running on the windows platform, I’ve also spent a bunch of time as a Mac user.
