Data Migration

INTRODUCTION   

PROJECT OVERVIEW

DATA MIGRATION is the project that goes around the development of GUI Universal Database Client.  It is the project that is intended to make the connection to different databases from single interface in an easy, fair, faster and reliable.

This software to be designed which deals with different databases and execute different kinds of SQL statements from a single Tool. Users can create the connections for each and every database and store it in the Tool. Later on the user can select connection name to connect to a particular database and start executing SQL statements. User can also execute select statements and see the results in the Tool only. Users can Commit or rollback the SQL statements.                                    

Objectives:

The objectives of the system are as follows:

·  To connect to different kinds of databases from single GUI Tool with Flexible and user-friendly screens. We can execute all the SQL statements from tool and see the results in the tool.

·   The user can commit or rollback the statement by just clicking the button

·   We can switch to any database by just switching the connections

·  The results has to be displayed and those results can also be exported to .CSV files

·  We can set the Timeout values for the connections.

·  To create the schemas from this tool

PROBLEM  OVERVIEW:

The present system has different tools or consoles for each and differently. The user feels uneasy to switch over to a different database by learning the how to use console for that database. If the user executes no of statements and after if he feels to store all these statements to port the same statements in different machine, it is not possible. For doing this each user has to store each and every statement by copying and pasting it in a file. User has to manually copy the results from the console and paste it in a file to store results of the query.

If the user wants to commit or rollback the statements then he has to manually type the commands in their consoles. If the user wants to undo or redo the tasks belongs to textual information then it is also not possible in most of the consoles.

This entire system needs to be performed from a single GUI tool which is common to all the databases for better performance and makes it user-friendly.

MOTIVATION OF PROJECT:

The proposed system will be developed on client/server architecture. The user can run this tool at their system and get connected to different database servers that are different locations (systems) very easily.

On creation of connection, the users can connect to a database by using that connection. For creating the connection the user has to fill out the parameters only once. This allows the user to connect and work with any no of databases from GUI environment. It provides a single GUI interface for managing different kinds of databases. This type of environment is mainly useful for Project Managers, Project Leaders and the user who interacts and works with different databases.This tool allows the user to store all the statements what he has executed to be stored as .SQL file. Later on the user can use that .SQL file to repeatedly execute the same set of statements.

The system also provides security by asking the password before get connection if we uncheck the option save password

AIM OF THE PROJECT:

· The user has to use GUI environment to connect to a database.

·  Different databases from a single user interface.

·  The user need not install any client libraries at the client system.

·  Provides a facility to manage the schemas.

·  The results to be displayed in the tool in effective manner

·  providing the minimum security

·  Reusing and holding the connection for some time.

Module

These are the Modules in this system:

·         GUI MODULE

·         CONNECTION MODULE

·         SQL MODULE

·         TRANSACTION MODULE

·         EXPORT MODULE

GUI Module: This module provides a graphical interface to make use of the features available in this tool. It catches the events and executes the functionality by co-coordinating with other modules.

Connections Module: This module provides a facility to create, edit and delete different connections and connects to a database if the user selects a connection. It allows the user to switch over different connections by making use of the same interface at the front end.

SQL Module: This module allows the users to execute any SQL statement using this tool and execute those statements on a particular database based on the selected connection. It allows us to make use of editing option cut, copy and paste in the SQL area. It also allows us to store the executed SQL statements into a file.

Transactions Module: It allows us to store support the transactions by making use commit and rollback options from this tool. It also allows us to store the result of an SQL statement in .csv format for later use.

Export Module: It allows us to export the database elements into a file and import the same also.

HARDWARE REQUIREMENTS:

·   PIII   500MHZ or above

·   512MB RAM or above

·   20 GB Hard disk space.

·   Network interface card or Modem (For Remote Sources)

·   LAN Network (For Remote Sources)

SOFTWARE REQUIREMENTS:

· WINDOWS 2003 | 2000 | XP

· JAVA VERSION JDK1.6 

· Any Oracle version, MYSQL, MS Access