It works well. I can connect to all my SQL Server servers using windows authentication & named instances, view tables, write and run queries, etc. The interface takes some getting used to, but I understand the challenge of squeezing at least the basic functionality of SSMS into a touch interface. 9.99/year is a very fair price, especially since you can use the basics for free. I’ve seen some sluggish performance, and auto-complete seems clunky at best (are these two connected, at least for me)? But it’s awfully nice to have a tool this good available on iOS.
I have been using iPads almost since the first one came out and never found a database client that worked well for me (been through numerous ones trying over the years) till now. Before had to pull out my laptop to do anything, now for most stuff I easily work on things from the iPad. Only infinitesimal issue I have is wish it had better options for execution plans since I need to optimize queries a lot, but that may not even be possible. Just so happy to have a client that works.
…how it saves configuration data across app and data deletion? Turned off iCloud access, deleted app and data, and verified that no iCloud usage is shown for the app. (Why iCloud access was allowed in the first place is also a little strange) Downloaded the app again and the old configuration data was back anyway, though, interestingly not the blocking of iCloud access!? Perhaps I did something wrong but before I don’t understand what is going on I am probably not going to subscribe to it. Too bad as it does what I need. Thanks in advance for any explanation.
I use this app intermittently to do quick checks on DB issues when I don’t have my laptop. I may go weeks or months without needing it, but I have the subscription auto-renew. At some point, the developer changed the subscription/license model with out notice! They continued to collect my license renewal fee under the old plan, but I can no longer use the App without a Key ( that I was never sent). There is no way I can find to contact anyone about this. I sent an email regarding the issue to both sales and support @ the devs main web address. Email did not bounce, no reply in months…
I’ve been using this in macOS for a long time and am stoked to finally see it in iOS! Having this on my iPad means a significant portion of my work can be done natively while mobile rather than having to log in to a remote workstation. Very highly recommend! Also, the developer is very responsive and helpful any time I came across an issue he would help me troubleshoot the problem to resolution.
I’ve long been a fan of this same app on MacOS. Its great to see an iOS version. This last release included an export of the entire result set which is infinitely better than manually selecting rows to export. Its nice that one connection is supported for free and multiple connections require an upgrade which is fair. However, I do feel the upgrade price is steep. Perhaps a tiered approach would be possible.
Updated review: Great software, but the pop ups are annoying. It may be Apples guidelines, but that does not mean it is respectful of your users’ experience.
Wow.... I used this free version for 60 seconds and knew it was well with the 150 one time fee to use for so many projects to come. You can literally execute procs, alter views, export the results to csv and even text the results all from within the app. Works perfect with my SQL server at home and azure. Well done gang!! 5 star!!
If you’re going to offer a free download with in app purchase, don’t lock query results behind the purchase. That is the most basic feature of a SQL app. And they happily let you TYPE the query (which is a pain on a small screen and keyboard) and RUN the query (which could take a while) but then lock the actual results. Just make it a paid app. I’m sure it’s worth the price, but I’m so annoyed by the tactic that I won’t even bother with this app.
This is a nice tool to have on the iPad, but the price is much too high for me to replace using Microsoft SQL Studio via Remote Desktop. I don’t see a whole lot of difference in the basic experience, which is perhaps a credit to the capabilities of SQLPro. Although it is nice to have an app for SQL queries, which is why I took a look at it, I don’t find that worth the price and loss of the full capabilities of SQL Studio.
Very nice app, the only professional-feeling SQL editor I’ve seen on iOS. I got it reading directly from GitHub using Working Copy. However it is too slow on my first generation iPad Pro. Anything more than 20 lines has a noticeable lag when typing. Past 50 lines, the lag is >1 second per character and unusable.
Fundamentally I really like the product but only on smaller Databases. When there is a large database the autocomplete function totally drags this app down to the point where its not usable.
this is one of the few app that really makes me use the Ipad for running my business instead of using the ipad jut to read emails on the go !!! the price is nothing compared with the benefits... Excellent Service and support from the developer, he has already added suggestions that make the app more usable !! will recommend it 110%...
Wish it supported Azure SQL DW — it DOES support normal Azure SQL (PaaS), but not Azure SQL DW (SQL Server Data Warehouse). It is SO close, but fails on connect because it tries to set ANSI_NULLS which is not supported on SQL DW.
Requires you to first sign up for a subscription before you can use any features. Sure, you get a week free, but at that point, they already have your data.
Upgraded my review to 5 stars. This is the best app of this kind. I tried many. BTW. Support was impeccable! Problem solved! — — — — — — — — — — — — — — — — — — — — Crashes on my iPad when I am in a results tab and click Edit. I can see the query history but couldn’t figure out how to save a query.
The old version could be used, even it can only support 1 server. Since the new version, you cannot use it anymore unless you have to pay to upgrade to premium version. Not honest!
Have on computer but want to connect to phone for mobility
Hello, I love databases and I am even taking an advanced sql server class I have tried and succeeded in creating multiple databases but my phone won’t connect to it I have all info needed but it is confusing which parts need to be used and what is left out, I already have a database to connect it to by sql server authentication and a login user with password but it goes from red to orange but never to green and I want to use it and I paid the one time payment of 149.99$ to them but I don’t know how to connect to my sql server on my phone and I need some help is there someone who could help me to figure it out
First, I have the trial installed on my MacBook and the free version on my iPad, and they blow away any competition. Beautiful design that is easy on the eyes, and really quick. I really hope I can keep using this on my iPad, the link described it as a beta. I’d happily pay to have this on my Mac and iPad, but $80 for the Mac version and $40 for the iPad is just too much, considering that even VS Code has the capability to do simple stuff in MSSQL. I think this developer has the ability to become the standard MSSQL IDE for Mac and iOS, but this price is just nuts. However, thanks to the developer for offering the iOS version free, this might just convince me to buy the Mac version too.
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: + Intellisense/SQL autocompletion. + Syntax highlighting. + Tabbed based interface for an optimal user experience (iPad). + Support for executing multiple queries at once. + Quick access to tables, columns and more. + Dark & Light themes which can be switched manually or automatically adjusted by your devices brightness. + Netbios support. + NTLMv2 supported (but not required). + SSH Tunnelling (password authentication only). Some of the great features include: + 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. Privacy Policy: https://hankinsoft.com/privacypolicy.html Terms of Use: https://hankinsoft.com/termsofuse.html Price: SQLPro requires a Premium upgrade in order to interact with database result sets. Premium is available as either a Lifetime Purchase or through a Subscription with Monthly and Yearly options. Subscriptions auto-renew within 24 hours of the expiration date unless auto-renewal is turned off in the iTunes account settings. Your Account will be charged for renewal (based on your selected plan) within 24-hours prior to the end of the current period. Any unused portion of a free trial period, if offered, will be forfeited when the user purchases a subscription to that publication, where applicable. Payment will be charged to your iTunes Account at confirmation of purchase.