Screenshots

Description

SQLPro for MSSQL is a lightweight Microsoft SQL Server database client, allowing quick and simple access to MSSQL Servers, including those hosted via cloud services such as SQL Azure or Amazon RDS.

Features include:
+ Syntax highlighting (including customizable themes).
+ Intellisense.
+ Tabbed based interface.
+ Support for executing multiple queries at once.
+ Quick access to tables, columns and more.
+ Stored procedure execution.
+ NTLMv2 supported (but not required).

SQLPro for MSSQL can be used to connect with the following databases:
+ Microsoft SQL Azure
+ Microsoft SQL Server 2005
+ Microsoft SQL Server 2008
+ Microsoft SQL Server 2008 R2
+ Microsoft SQL Server 2012
+ Microsoft SQL Server 2014
+ Microsoft SQL Server 2016

Thanks to the FreeTDS project (http://www.freetds.org/) for their great library.

This SQL Client does NOT work with MySQL or Postgres. Please ensure that your server is a Microsoft SQL Server (2005 or above).

Note 1: SQL Server Express is supported, however using it makes me sad. Please confirm that the SQL Server Express installation has been configured properly for remote connections over TCP/IP, and that you can connect remotely from another windows pc before requesting support.

Note 2: SQLPro for MSSQL can connect to Microsoft SQL Server 2000 however it is not supported.

What's New

Version 1.0.200

+ Added a context option for scripting indexes.
+ Scripting tables will now include calculated field definitions.

Ratings and Reviews

Many needed improvements included in this version

crashkaboom

I purchased this app back when it was young and limited as an alternative to SQuirrel SQL. I’ve recommended it as a great native query analyzer to many coworkers over the years but always with a few important caveats, including but not limited to: the lack of streaming results, the lack of “SCRIPT TO” context menus, the clumsy connection screen (return not working as a shortcut), and awkward intellisense. All of these issues seem to be addressed now, and I’m a very pleased user. Crashes were few and far between in the past, but I haven’t had any freezeups or crashes with this latest version. The author is quick to respond to issues/bugs/feature requests in product's message board and/or emails. The UI keeps getting better each release and in my opinion, it’s very close to a lite* SQL Management Studio replacement. My only complaint is the price seems a bit too high for a query analyzer that only handles SQL Server databases and lacks more robust debugging and optimization features, but otherwise, it’s a great app.

* obviously this app lacks a large majority of SSMS’s advanced features, but it’s a solid tool for query analyzation and editing tables, views, functions and stored procedures

Great Software / Great Developer

ChrisOndrovic

This is a great peice of software it’s nice to have a native solution for MSSQL on a mac machine.

So I too had the problem of it not wanting to install from the App Store, I download the trial software from the developers website, upon purchasing this I too experienced the stuck in waiting behavior it’s not an issue with the software more of launch pad. Here is how I corrected it

1. Open LaunchPad
a. find the app hold option key so the (x) is displayed, click on it answer yes to the do you want to delete
2. If you downloaded the trial make sure to remove from /Applications or where ever you installed it to
3. Reboot your mac, this clears the caches
4. Launch App Store, goto Purchase -> Select your item -> click install

At this point it should install correctly

Great developer, I have spoken with the developer a numerous amount on times, asking questions, reporting bugs if found, etc, to which the developer is very responsive and more than willing to help. I wasn’t expceting to get an email back the same day I send a contact email, but within 20 minutes I had a response with an answer that solved my problem and in a very professional manner.

I would defenitly do business with them again on some of their other products.

Awesome!

rlbaxter

I tried several different mac clients for interfacing with mssql. Most of these were java apps which looked hideous, and I had to mess around with downloading development kits and trird party drivers, and even then couldn’t get everything to work. This just works, and it looks great to boot. $50 was a little more than I was looking to spend, but after seeing the competition it was well worth the small investment.

Most of the negative reviews are from users expecting features the software didn’t have. There is a trial version avalible online. Download it and use it for the full 7 days before you get all grumpy that it dosen’t have something. It works great for my needs.

Information

Seller
Hankinsoft Development Inc
Size
5.9 MB
Category
Developer Tools
Compatibility
Languages
English
Age Rating
Rated 4+
Copyright
© Hankinsoft Development, Inc
Price
$79.99

Supports

  • Family Sharing

    With Family Sharing set up, up to six family members can use this app.

More By This Developer