SQL Server Mobile Client PRO
iOS Universel / developpeurs
DB Compass for SQL Server allows you to access your MS SQL Server database directly and without any server setup. You can manage your data with a clean and simple iOS user interface.
FEATURES:
• Connection with the SSH tunnel build-in with password or key authentication
• SSH authentication support Secure Enclave Key and U2F/FIDO NFC Key
• Table data: browse, filter, sort
• Table structure: rename and drop for tables and columns
• Pick FK value for foreign key field
• 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 User list and Privileges
• Login information stored in (local or iCloud) KeyChain
• Table data: add, edit and delete record
• Blob preview and export
• Blob update (from iOS Photos or Files)
• Geometry/geography data viewer (only from table)
• Export data grid to CSV, JSON, HTML, SQLite, 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
• Job Activity Monitor
• JS script (with db access)
• Charts & Widgets
• OpenAI integration (requires your key - allowed regions only)
• Ollama integration (requires your server to connect to)
Tested on SQL Server 2012, 2017 and Azure SQL Database.
Does not support dynamic TCP port in conjunction with SSH tunnel.
For feedback or suggestions contact info@dbcompass.net
Quoi de neuf dans la dernière version ?
• New chart features: trendlines, reference lines, data symbols customizations, and dynamic axis titles
• Chart widgets can also be placed on the Lock Screen
• New Import dBase files (DBF)
• New Logical Expression in grid filter and Global Search
• New Light/Dark UI mode selection
• New Customizable colors in HTML Grid Export
• Fixed date field on devices with non-Gregorian calendar
