Database migration is considered of vital concern in the IT services industry. In
the fast evolving IT industry, there is always a growing need for new trends calling
for outstanding performance and higher efficiency.
Database migration is a set of activities that move the data and schemas from one
or more legacy systems (or “source systems”) to a new application (or “new
systems”). The purpose of database migration is to preserve core business
knowledge and make it accessible from the new application.
DBXMigrator helps in the migration of the cross database from platforms. This
database migration involves the migration of schemas and tables along with the
data contained in these tables based on the preferences of the user.
DBXMigrator provides a sophisticated tool to migrate data from one data source /
legacy system to another data source / new system. The data source can be of any
type like legacy systems, DBMS, RDBMS, Flat files , etc.
DBXMigrator facilitates the security transfer of the data through out the network
by implementing the Encryption / Decryption.
DBXMigrator provide increased availability by migrating the source database into
intermediate form and when the destination required it will support to migrate to
the requested format.
The IT related Business Industries are following manual process and relaying on
different tools for different platforms and different databases. The Database
Administrators , in manual process executing tedious command line statements
and migrating the databases. If the database is same they are following one
particular command line statements and if the database is different they are
following different command line statements. The DBA’s Who are relaying on third
party utilities to migrate is utilizing based on the requirements like databases. If
the database is same and they are following one particular tool and if the
database is different they are following different tool.
Drawbacks of the Existing System
The time taking for the manual process is more because it depends on
the capability of the human.
Different Technologies needs different technically skilled people.
The cost invested on man power is high
Data Consistency may not be assured.
Security not implemented.
DBXMigrator is a full-featured, Client/Server database Migration System
that is integrated into the many database environments. Provision of UI to collect
the source and target database information .Databases that DBXMigrator is
supported on include Oracle, SQL Server, MySql and Microsoft Access. Routine
management reports, secure reports allow many type of users easy access to
DBXMigrator flexibility makes it ideal for today's rapidly changing
business environment, as it is able to manage all the aspects concerning data
management. Also it has support for the today's most used database engines:
MySQL, MSAccess, MSSQL Server and Oracle.
The Process Implemented in this software as follows. The Administrator
will be using this system after login ,by giving authentication details to
“DBXLogin “. Once the login is successful , configuration of database resources
can be performed using “DBXConfig” , module. When the database has to be
migrated to one to any , the source data can be exported to an inter mediatory
form using “DBXExport “ , module , and it will be Encrypted By “DBXSecure”.
When The destination machine requested to migrate the Data source to the local
database , The Encrypted inter mediatory form will be transferred to the client
machine using , DBXServer and DBXClient Modules. Once It reached destination ,
there it will be Decrypted using DBXSecure Decrypt , and That Inter mediatory
form will be migrated to the local database using the “DBXImport”.
DBXImport: The import utilities are used to perform logical database
Recovery. They are also used to move data from one machine to another.
This Import Utility supports to migrate the data from destination to
DBXExport: The Export utilities are used to perform logical database
backup They are also used to move data from one machine to another.
This Export Utility supports to migrate the data from source to
DBXLogin: This ensures the usage of the software by the authorized
users only. The "Basic" user-authentication allows you to restrict access
to users who can provide a valid username/password pair. The
DBXLogin provides with a interface to authenticate users.
DBXConfig: This supports to configure the hosts which the data has to
DBXLogs: It is provides the history of the actions performed by the
Server, by recording the transactions , and supports to review when
DBXSecure: This will implement the secured transaction of data while
transferring the resources , by implementing the encryption , decryption
DBXServer: This provides a service by an controlling hosts and
accepting communication from a client , and migrates the data
according to the requirements.
DBXClient: This supports to migrate the data in destination machine
according to the server instructions.
There are many benefits where this can be of great value, including:
Moving Development database to a Production environment;
Moving an existing database from one database product to another (e.g. SQL
Server to Oracle);
Complete range of database migration tool for Oracle helps customers to
migrate their business environment to Oracle without tedious manual
Flexible, open and extensible migration process.
Rapid data migration across databases ensuring data integrity with no loss
Migrates data across databases deployed on different database
Easy to Install and Easy to Use tool with user friendly & intuitive GUI
Provides a uniform approach for migration across different databases.
Pentium IV 2.8 GHz
128 MB RAM
40GB Hard Disk
PROPOSED ACTUAL DATES
S.NO ACTIVITY START END START END
DATE DATE DATE DATE
Data Flow diagram
A data flow diagram is graphical tool used to describe and analyze
movement of data through a system. These are the central tool and the basis
from which the other components are developed. The transformation of data
from input to output, through processed, may be described logically and
independently of physical components associated with the system. These are
known as the logical data flow diagrams. The physical data flow diagrams
show the actual implements and movement of data between people,
departments and workstations. A full description of a system actually consists
of a set of data flow diagrams. Using two familiar notations Yourdon, Gane and
Sarson notation develops the data flow diagrams. Each component in a DFD is
labeled with a descriptive name. Process is further identified with a number
that will be used for identification purpose. The development of DFD’s is done
in several levels.
A DFD is also known as a “bubble Chart” has the purpose of clarifying
system requirements and identifying major transformations that will become
programs in system design. So it is the starting point of the design to the
lowest level of detail. A DFD consists of a series of bubbles joined by data flows
in the system.
Context Level DFD
Database to be Confirmation of
Level 1 DFD
Ack Host Data
User Manager Hosts
Ack User Details
Ack Details Encrypted
DBXLogs Source Data
DBXServer Intermediate form Data DBXClient Client Data
Server Data Status Status
Repository Source JOB Status Data Ack
Migrated Database to
Data Configurati Exported
Ack Intermediate Source
Data Form on at be
DBXExport Administrator DBXImport
Status MS Access
Ack Engine Status
Request for Ack
SQL Server DBXEngine Request Request for MS Access
for MS-Access SQL Server DBXEngine Engine
Request for Flat file
Engine SQL Server Request
Request for Flat file
Ack Engine Ack for MS-Access
Request for ORACLE
Request for ORACLE
ORACLE Flat file Ack
Engine Engine ORACLE Flat file