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:
http://your-domain.com/includes/1ClickDBPro/default.asp
1 Click DB Pro
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:
1 Click DB Pro Login
Below are some screen for your reference:
1. List Tables
1 Click DB Pro List Tables
2. View Table Data
1 Click DB Pro View Data
3. Manage Table Structure, Indexes, Constraints, Triggers
1 Click DB Pro Manage Structure, Indexes, Constraints, Triggers
4. Run Or Import SQL Commands
1 Click DB Pro Run 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.
