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.
