This is a tool that can help migrate data from MySQL database to Oracle database.
This tool helps migrate data from one database to another automatically. This utility is for transferring data from MySQL database to Oracle database. Migrating through this tool saves a lot of time as this program is able to complete the job on its own and you do not need to do things manually. IT department personnel thus would be able to save considerable time when such data migrations are required often. There are three different ways transfers can be set up. One is the straightforward one to one transfer of data from a table in MySQL to a table in Oracle. There is a multi-way transfer through query which can be a “n to 1” transfer. Then there is the n table to n table transfer mode. Configuring the transfer is visual. The interface helps to make this simple. The IT types should be able to get used to this interface quite easily. You need to specify the two data base tables which are involved in the transfer. There can be only specific fields involved in the transfer. You need to set up this correspondence before starting the transfer.
A progress bar shows you what percentage of the transfer has been completed. It also shows the number of records completed and the elapsed time taken. The bar itself gives you a visual indication of how much work is done and what’s left to be done. Though it is fairly simple, there is a wizard available to help the user set things up. The session parameters can be reused. Preview shows you how the data transfer has been done, if errors have happened. When transferring, non-English data does not pose any problems, it is Unicode compatible. When you have data transfers to be done regularly, scheduled transfers help a lot. Command line could be used to set up transfers efficiently. This is a very good tool.