Contact at mumbai.academics@gmail.com or 8097636691
Responsive Ads Here

Tuesday, 13 February 2018

Query Migration Assistant

Query Migration Assistant

Abstract:
Technology continues to grow by leaps and bounds as the days go by and computers are in a certain position to overtake from the manual labor in diverse fields ranging from mechanized applications to Intelligent Thinking Systems. In this computer age, handling large and voluminous amounts of data is not a feasible solution neither is it an efficient investment. Many existing Firms employ manual labor for transferring large files and huge amounts of data between two databases utilizing a particular scheme. This eventually raises a spark in the mind that if ever there exists a service that is going to perform the difficult and time consuming task of moving the data between two databases well Query Migration Assistant is just that.
Query Migration Assistant is an innovative database migration product that easily converts data from one database to another. This service automates the entire migration process of converting data, database objects and constraints.  Manually converting data from one database to another is risky and it takes long period of time. So, by using this migration toolkit we convert the tables from one database to another with less time, more accuracy and error free.
The main reason that can be attributed for the manual labor is that either due to insufficient investments as the existing migration services are a lot costlier and so on. Query Migration Assistant is a freeware application that can be said to be a boon for the firms which cannot afford to buy a Migration tool. Another Important feature of this service is that it provides the scope for handling multiple Databases in migrating data in both ways that is bi directional data transfer.
The scope of the project is the Development of a Toolkit which supports the data transfer from one Database to the other database.  The scope of the project lies in the development of the kit for the transfer of data  between any   two databases. Query Migration Assistant automates the entire migration process converting data, database objects and constraints from Source data base to target database and viceversa.This Migration Tool Kit is mainly used when dealing with large volumes of data.
This project is divided into 2 modules:
ü  Handling from Source Data Base to Target Data Base:      
This module includes the handling of data with respect to the Source database using .net as the intermediate tool.
ü  Handling from Target Data Base to Source Data Base:  
This module includes the handling of the data with respect to the Target database using .net as the intermediate tool.
PROBLEM SPECIFICATION
The  objective  of  proposed  system is to migrate the data between the source database and the target database.The system should keep track of feedback from the user and should view the program undertaken by the system .
The proposed system must allow the user to select the service.  It   would provide the facilities for the following module.
Ø  Access and Oracle migration
Ø  Oracle and SQL Server migration
Ø  SQL Server and Access migration
Only the authorized person can log on to their modules using the login name and password.
In Access to Oracle migration module, once a user logs on to the system, he/she can select the tables that are needed to be migrated , and view the feedback of the end users.
He/She can migrate the data from any access file by specifying the source file path to any user account in the target oracle database.The source Access file path should be with a .mdb extension and the target database should be specified with the user name ,password and the host string . 
 In Oracle to SQL Server migration module, once a user logs on to the system, he/she can select the tables that are needed to be migrated , and view the feedback of the end users.
He/She can migrate the data from any user account in the source Oracle Database by specifying the source file path to any user account in the target oracle database. The source Database should be specified with a uer name,password and the host string and the target database should be specified with the user name ,password ,database name and the data source . 
In SQL Server and Access migration Module, once a user logs on to the system, he/she can select the tables that are needed to be migrated , and view the feedback of the end users.
He/She can migrate the data from any user account in the source Access File by specifying the source file path to any user account in the target SQL Server database.The source Access file path should be with a .mdb the target database should be specified with the user name ,password ,database name and the data source . 
EXISTING SYSTEM
At present the database tables are carried out manually.  We can create the database tables manually means it has a long period of time.  The organization should be fast with well-visualized future plans.  The volumes of data to handle are increasing constantly.  It is also necessary to speed the processing of database tables. And if at all there is a service to migrate the data it is only one way of migrating the data
Limitations of the Manual system
  • It is time consuming
  • It leads to error prone results
  • It consumes lot of manpower to better results
  • It lacks of data security
  • Retrieval of data takes lot of time
  • Percentage of accuracy is less
  • Reports take time to produce
  • Limitations of the One way migration system
  • The source and the target database will be fixed
  • If  there is a need  to transfer the data to another database basing on the requirement the another software must be available.
PROPOSED SYSTEM
General Description
The proposed system provides a fully structured but skill versatile automated data migration process.  It has full control of source and target data.  It provides a high quality data with no data loss.  The system will be consistent, accurate and cost effective.  It provides efficient utilization of available resources.  It supports partial or incremental migration.  It also supports for multiple runtime environment.
·         The System eliminates all the error prone packages of the earlier migration services.
·         It provides an online migration process
·         The online migration process saves time because one need not have to dpwn;oad the entire application to transform the data.
·         It provides the scope for migrating data between multiple databases.
·         It also atransforms the data bi-directionally which a lot of exixting tools cannot provide.
·         It can transform Lob’s,binary formatted text, Ole Object’s etc.
Hardware Environment
RAM                                     - 128 MB
Hard Disk                              - 20 GB
Processor                               - Intel Pentium 500MHz
Floppy Disk                           - 1.44 MB
Cache                                     - 256 K
Monitor                                  - Color Monitor (256 colors)

Software Environment

Operating System                   - Microsoft Windows 2000/XP/NT
Front End Tool                       - Microsoft ASP .NET
Scripting language                 - C#.NET
RDBMS                                  - Oracle 8i   , SQL Server       
Application Server                 - Internet Information Service 4.0

No comments:

Post a Comment