This is a tool that can help migrate data from MySQL database to Microsoft SQL Server.
This tool can take care of the data migration automatically. This tool is suitable for migrating data from MySQL database to MS SQL Server database. Since it migrates the data on its own, this will be able to save a lot of time for your IT department personnel. Configuring the transfer can be done visually. 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. Whole table need not be involved. You set up the correspondence between source fields in each record to the source field in destination record. When initiated, there is a progress bar available that show the transfer completion. You also get an indication in percentage terms and number of records completed.
The session parameters could be saved so that they can be used again and again. Preview is available to make sure transfer happened without errors. Initially when a user is not completely familiar, this tool has a wizard that takes you through the process. It is also possible to do transfers based on a query and transfer multiple tables to multiple tables. As Unicode is supported the database data could be in any language. There is a command line mode and a scheduled mode. When such transfers need to happen regularly and unattended, these two modes are useful. This is a very good tool.