We usually use phpMyAdmin which is written in PHP to manage MySQL but with SQL Server or Oracle, there is a tool called 1 Click DB which is an Open Source Web Database Administration using ASP to handle almost features to manage database, tables, indexes, users and triggers via a web-based interface.
To install the 1 Click DB web-based software, simply download it, unzip the downloaded file then upload to your web server. Note that your web server have to install Microsoft IIS Web Server and support ASP.
Assume you uploaded all the extract files to your server and it’s ready t access via url:
You need to specify which database server you want to manage: SQL Server, Oracle or even MySQL. For example, click on SQL Server link, it redirects to login page, let’s type the IP/Host name of the database server, Database Name, Username and Password like this:
Below are some screen for your reference:
1. List Tables
2. View Table Data
3. Manage Table Structure, Indexes, Constraints, Triggers
4. Run Or Import SQL Commands
There are more functions which allow you to create, edit or delete your Stored Procedures, Views as well as manage or export table data.
It’s easy to install, easy to use and very similar to phpMyAdmin. If you’re looking for an open source web-based for your SQL Server Database Management, it is my recommend for you. Try and let us know your thought or if you have any good solution, please share.
I uploaded a copy of the 1ClickDBPro version for you be able to download.