Truemag

  • Categories
    • Tips And Tricks
    • Internet
    • PHP
    • Javascript
    • CSharp
    • SQL Server
    • Linux
  • Lastest Videos
  • Our Demos
  • About
  • Contact
  • Home
  • Write With Us
  • Job Request
Home SQL Server Free Web Admin For Microsoft SQL Server And Oracle – 1ClickDBPro

Free Web Admin For Microsoft SQL Server And Oracle – 1ClickDBPro

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

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

1 Click DB Pro Login

Below are some screen for your reference:

1. List Tables

1 Click DB Pro List Tables

1 Click DB Pro List Tables

2. View Table Data

1 Click DB Pro View Data

1 Click DB Pro View Data

3. Manage Table Structure, Indexes, Constraints, Triggers

1 Click DB Pro Manage 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

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.

May 7, 2011Hoan Huynh
How To Filter DataBase Name And Login Username In SQL Server ProfilerFree Mysql Profiler similar to Microsoft SQL Server Profiler - LogMonitor
You Might Also Like:
  • Free Mysql Profiler similar to Microsoft SQL Server Profiler – LogMonitor
  • Install ASP On Microsoft Windows Server 2008 IIS 7.0 and IIS 7.5
  • Free Cloud Server For Testing
  • How To Check Which Stored Procedures Or SQL Commands Are Running On SQL Server
  • How To Filter DataBase Name And Login Username In SQL Server Profiler
  • Create Free SSL Certificate For Testing On Windows Server 2003 IIS 6
  • Setup Free SSL Certificate For Testing On Development Environment In Windows IIS 7
  • Capture And Display Execution Time Of SQL Query In SQL Server
  • Export/Import Data From Local Database To Remote Database With MS SQL Server 2008
  • Save Table Structure Changes When Remote Access To SQL Server
Hoan Huynh

Hoan Huynh is the founder and head of 4rapiddev.com. Reach him at [email protected]

11 years ago SQL Server1 Click DB, 1ClickDBPro, Database, phpMyAdmin485
0
GooglePlus
0
Facebook
0
Twitter
0
Digg
0
Delicious
0
Stumbleupon
0
Linkedin
0
Pinterest
Most Viewed
PHP Download Image Or File From URL
24,542 views
Notepad Plus Plus Compare Plugin
How To Install Compare Text Plugin In Notepad Plus Plus
21,885 views
Microsoft SQL Server 2008 Attach Remove Log
Delete, Shrink, Eliminate Transaction Log .LDF File
17,736 views
JQuery Allow only numeric characters or only alphabet characters in textbox
15,059 views
C# Read Json From URL And Parse/Deserialize Json
11,789 views
4 Rapid Development is a central page that is targeted at newbie and professional programmers, database administrators, system admin, web masters and bloggers.
Recent Posts
  • Things to Learn about Installingderm Loan Type S
  • Online Photo Editor – Free Photoediting Software
  • A Guide to Finding the Best Paper Sellers
  • Photoediting in Home Isn’t Hard to Do!

  • Free Photo Editor Online
Categories
  • CSharp (45)
  • Facebook Graph API (19)
  • Google API (7)
  • Internet (87)
  • iPhone XCode (8)
  • Javascript (35)
  • Linux (27)
  • MySQL (16)
  • PHP (84)
  • Problem Issue Error (29)
  • Resources (32)
  • SQL Server (25)
  • Timeline (5)
  • Tips And Tricks (141)
  • Uncategorized (647)
Recommended
  • Custom Software Development Company
  • Online Useful Tools
  • Premium Themes
  • VPS
2014 © 4 Rapid Development