Abstract
Today there are several different databases systems in the market and many organizations work with multiple databases, heterogeneous in nature. Each of these systems store data and have applications running with them. In such a scenario there are instances where these organizations want their databases to interoperate and cross-populate the back end data repositories. Few of such instances when organizations would need heterogeneous database systems to communicate with each other are during mergers and acquisitions, during legacy system modernization or during an enterprise application consolidation. This project aims at implementing a tool which will help in transfer of data from one database to another database which is heterogeneous from the earlier one. The two heterogeneous databases that have been used in this project are MS SQL Server 2008 and MySQL 5.0. The tool will extract the table definitions including all the primary key, foreign key, index definitions of a particular table or tables in MS SQL Server and convert that definition into a script that can be run on MySQL database to produce a replica of the table/tables present in MS SQL Server. The tool then transfers the data present in the selected tables from MS SQL Server to MySQL. The tool will have an interactive GUI and will automate the entire process of data transfer with little manual intervention.