In my opinion this is not a professional version. The UI has lacks in interaction. After bought EDIT feature, this is not updating the MS-SQL Record. Using SQL statement does not update neither. Using other editors with same MS-SQL server and user/schema the CRUD functionalities works great. So, this is a bug of this version. Please, can the author process a refund ?
Estimation application downloads and cost
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. With the In-App Purchase Edit Data you can edit it directly on your Mac.
* 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.)
In-app Purchase 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
In-app Purchase 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.
In-App Purchase 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
* Configable URL Path, template and server port
* Build-in 10+ Html Table Template
In-App Purchase App Builder
* Build customised 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
Schema: Northwind
(This can not be empty for Windows Azure SQL Server)
Read more
* 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.)
In-app Purchase 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
In-app Purchase 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.
In-App Purchase 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
* Configable URL Path, template and server port
* Build-in 10+ Html Table Template
In-App Purchase App Builder
* Build customised 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
Schema: Northwind
(This can not be empty for Windows Azure SQL Server)
SQL Server Manager screenshorts
Application availability
Available in countries
| Country | Price |
|---|---|
| Canada | 6.99 CAD |
| China | 30 CNY |
| France | 5.49 EUR |
| Germany | 5.49 EUR |
| Italy | 5.49 EUR |
| Netherlands | 5.49 EUR |
| Portugal | 5.49 EUR |
| Spain | 5.49 EUR |
| Poland | 5.49 EUR |
| UK | 4.99 GBP |
| India | 399 INR |
| Japan | 600 JPY |
| Poland | 23.99 PLN |
| Russia | 379 RUB |
| Turkey | 22.99 TRY |
| USA | 4.99 USD |
| Korea, Republic Of | 5.49 USD |
| Ukraine | 4.99 USD |
Available for devices
MacDesktop,Reviews
Do not buy! This is “in dev version"
Unbrauchbar
Stürzt bei Zugriffen auf Größeren Tabellen (MS-SQL Server 2014) ab. Stellt auch nur die ersten Datensätze kleinerer Tabellen dar - wen ein Zugriff gelingt.
FAKE
i have spent 15 euro and is not possible to connect to AZURE, total waste of money
Columns not liging up with data
I have a table with about 10 columns. The data for each column is ligning up under the incorrect field name. Please fix this and it will be a good app. Thanks
No Windows Authentication
It wasn’t until AFTER I purchased this app that I discovered it doesn’t support Windows Authentication. Super disappointing, especially because that’s the way everything is set up at work. $5 wasted on something that I now know is useless to me.
needs work
It keeps freezing and then failing and I have to reconnect and retry the operation. To be fair Navicat for SQL Server does that also. Also there is a bug where dates in the grid are not formatted properly — they are YYYY-DD-DD (the month is replaced with the day).
Other apps from 强 李
Similar apps
