Screenshots

Description

Connect to Microsoft SQL Server/Azure SQL Server/Sybase ASE on your Mac with SQL Server Manager, you can view data easily with Filter, Sort, Paging , and edit data directly on your Mac.

(This version have all features without in-app purchase product)

* Connect directly to Microsoft SQL Server , Windows Azure SQL Server and Sybase ASE, no middleware needed.
* Browser database tables and views
* View table data with paging table list, column resizable
* 10+ data view UI control (include Map, Date Time, Checkbox, Rating, Color,Dropdown, Multi-select ...)
* Sort table by click on the column
* Show cross table data value by ID ( use the Data Picker Setting )
* Filter/Search table data on column
* Sort table data by click on the column header
* Choose tables to show and columns to show
* Drag drop rearrange column order and change column width in main table
* Zoom data via change data font size
* CSV View and export
* Html View with customisable template
* Works great with companion mobile app 'SQLServer Database Manager' for iPhone and iPad

(Windows Authentication is not supported.)

'Edit Data' Features:
* 10+ data edit UI control (include Map, Date Time, Checkbox, Rating, Color Picker,Dropdown, Multi-select...)
* Update table row data
* Delete table row data
* Add table row data
* Cross table ID,Value single or multi-select using the Data Picker

'Map View' Features:
* View Geolocation on map
Support two format:
1. Latitude and Longitude column data;
2. any column contain this format geolocation: {lat:11.123,lng:34.56}
* Auto update Geolocation by search address
Select address column to search, and select save to column to save the found geolocation.
Please select the column which have enough length to save Latitude and Longitude.

'Instant Web Server' Features:
* Publish data on local network with one single click, view and add data on any web browser from mobile devices or computers
* Easy setup template for list page and detail page
* Build-in form to add data
* Config URL Path, template and server port
* Build-in 10+ Html Table Template

'App Builder' Features:
* Build customized User Interface for your database
* Bind database table row data to user control
* Support Rows Table List, Row detail data controls, search field


Microsoft SQL Server Connection Config Example:
Server: 192.168.2.1
(IP address of the server, or domain name)
Port: 1433
(Default is 1433, or change to your customised configuration)
User: sa
Password: password
Schema:
(This can be empty, will list all database when connect)

Sybase ASE Connections Conifg Example:
Server: 192.168.2.1
(IP address of the server, or domain name)
Port: 5000
(Default is 5000, or change to your customised configuration)
User: sa
Password: password
Schema:
(This can be empty, will list all database when connect)
Sybase ASE: checked

Windows Azure Config Example:
Server: myazureserver.database.windows.net
(server address)
Port: 1433
(Default is 1433, or change to your customised configuration)
User: user@myazureserver
Password: password
DB.Schema: DBName
(This can not be empty for Windows Azure SQL Server)

What’s New

Version 2.0

- Update for Mojave, Dark Mode fully support.
- Demo Server Fixed.
- Update App for Sql Server and Azure new version, Sample Config:
Server: YourServer.database.windows.net
Port: 1433
User: YourUserName
Password: YourPassword
Instance:
DB.Schema: YourDatabaseName

Ratings and Reviews

jhawthor ,

Waste of $15

This app is completely worthless. It will only load tables based on schema. Aweful interface to access data and run queries. SQLPro is way better though its $80. You ca ndownload a trial to evaluate. Also MySQL WorkBench (Free) works better.

Ghost.Sage ,

Missing major components

Missing Windows Authentication API, if your working in a trusted domain environment this tool will not do well at all only authentication that it’s capable of is SQL Server Authentication, which is not the best Security Practice when working with SQL Server.

TheC-man ,

Shows incorrect data!

Aside from all the problems I encountered in connecting to my database…
Aside from the lack of decent documentation or instruction…
When I finally *DID* get to the point of retrieving data from my tables, the data from date-time fields is consistently displayed incorrectly! For example, a date-time that should be 2016-04-01 13:37:31 (which would be yyyy-mm-dd hh:mm:ss) is shown as 2016-01-01 13:37:31 (yyyy-dd-dd hh:mm:ss).
This is fundamentally a data retrieval and display tool, but if something as simple as date formatting is corrupted it can’t be relied upon.
I wasted $15!

Information

Seller
John Li
Size
9.1 MB
Category
Business
Compatibility

OS X 10.9 or later, 64-bit processor

Languages

English

Age Rating
Rated 4+
Copyright
© 2019 John Li
Price
$9.99

Supports

  • Family Sharing

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

More By This Developer