Virtual DBA for SQL Thin Client

Abstract

The users has to connect the company database remotely and make requested changes. This project allows the users to connect with the database without having any client software�s to be installed. The DBA and the other employees working on MS SQL Server can access it if and if it is installed in the machine, if the MS SQL server is not installed it is impossible to get connected and work with the server. If the DBA is not in the organization and it is very immediately require restoring or taking the back-up of the database or any other tsk like that, the DBA can get connected to the server only through a machine in which MS SQL server is installed. The only requirement is web browser. The current study presents a tool for remote database administration that is executed through web application. The web application provides database administrators (DBAs) to perform their task by automatically identifying databases. The proposed tool provides database administrationservices anywhere and anytime. Furthermore, the proposed tool enables DBAs to Manage databaseresiding in mobile hosts or famed hosts. The MS SQL Server has to be installed in the server machines, through which the workers will access the respective databases to write there codes. The DBA too can access the MS SQL Server only if it installed in the machine. If MS SQL Server is not installed in the machine neither the DBA can access the server nor can the workers access it. Therefore in the present study we are developing a web application which helps us to perform the entire DBA tasks can creating user, setting the access permissions, creating databases, taking back-up of the database, restoring the database etc.