10-04-2017, 09:27 PM
The proposed project "Universal Web Administration tool for Database" is an online tool that can be used manage databases like MySQL, MSSQL, Postgre SQL etc..
Proposed Features
Support for most Databse features:
browse and drop databases, tables, views, fields and indexes
create, copy, drop, rename and alter databases, tables, fields and indexes
maintenance server, databases and tables, with proposals on server configuration
execute, edit and bookmark any SQL-statement, even batch-queries
manage users and privileges
manage stored procedures and triggers
Import data from CSV and SQL
Export data to various formats: CSV, SQL, XML and others
Creating complex queries using Visual Query Designer
Searching globally in a database or a subset of it
Working of the Application.
To acces a database remotely the user need to supply the address of the server, user name, password, database name etc to the initial screen of the application. The proposed project works in conjunction with Enterprise Database Integration server project posted in this website earlier. Appropriate screens will be provided to the user for tha database actions like insert,delete,edit,query options. The request from the users will be parsed by the application and will send to the Enterprise Database Integration server for execution. The results that returned from the server will be displayed to the user