SQL Server Mobile Client 4+

Name: SQL Server Mobile Client
Rating: 4.1 (48 reviews)
Author: Filippo Maguolo

Filippo Maguolo

- 4.1 • 48개의 평가

- 무료
- 앱 내 구입 제공

설명

SQL Server Mobile Client allow you to access your MS SQL Server database directly and without any server setup. You can manage your data with a very clean and simple iOS user interface.

BASIC FEATURES:
• Connection with the SSH tunnel build-in with password or key authentication (DSA, RSA, ECDSA, Ed25519, Secure Enclave)
• Table data: browse, filter, sort
• Table structure: rename and drop for tables and columns
• Free query with assisted composition and plan analysis
• View and Call Functions and Store Procedures
• View database and table information
• View and manage sessions
• View ER Diagram (interactive and with PNG/PDF export)
• View Job Activity Monitor
• View User list and Privileges

PRO FEATURES (with in-app purchase):
• Login information stored in (local or iCloud) KeyChain
• Table data: add, edit and delete record
• Pick FK value for foreign key field
• Blob preview and export
• Blob update (from iOS Photos or Files)
• Geometry/geography data viewer (only from table)
• Export data grid to CSV, JSON, SQLite, HTML, Excel and MSAccess(XML) format
• Export table to CSV, NDJson and SQLite format
• Import of CSV, SQLite and MSAccess(MDB/ACCDB) tables
• Browsing of DB structure within a query or a record editor
• iCloud Sync for saved query statements
• Shortcuts support
• Table/View updates in grid
• JS script (with db access)

Tested on SQL Server 2012, 2017 and Azure SQL Database.
Does not support dynamic TCP port in conjunction with SSH tunnel.

2024년 2월 4일

버전 31.1

• New JS script (with integrated db connection and charts generator)
• New manual grid data page navigation
• Added support for FIDO Key in SSH tunnel
• Bug fixes

4.1/5

48개의 평가

Great app for the price

I sprang for the Pro version for $9 or $10. It allows saving of connection strings.
Keep in mind that this is NOT an iOS ‘replacement’ for Microsoft SSMS, which BTW has a 2 GB install footprint (larger than SQL itself). But it does have good access to tables, views, procedures, etc. and is Data Type aware when entering or editing data.
Works fine with Azure SQL Db. If you can’t make it work, it’s probably an IP rule blocking you on your Azure SQL Server and NOT a limitation of the app.
I signed up for the Beta program to help the developer fix some minor issues and test early releases. He was very responsive and helpful.

Very nice App

I agree with Jonatious this is great app so not sure why either the low rating unless the ratings are from the competition. Easy to use and does everything I have tried in it so far. I’m practicing for a MS SQL cert so the app lets me do this on the go. Contacted the developer with a list of questions before I purchased the app and within 24 hours they had responded with very detailed answers. Awesome app and support!

Works great with Azure SQL

Does everything I need, let’s me stop being preoccupied with data imaginings since I can get in and work with real queries when pulled away from my computer. Really fantastic app in terms of capabilities. Responsive, and despite older reviews saying otherwise, it’s connecting just fine to Azure SQL.