This is a tool that helps importing DB2 data to MS SQL database.
Often a development shop or an organization handles multiple databases at any time. Quite often there is a need to transfer data between the databases. This is a handy utility that can help take care of the transfers quite easily and quickly. DBA and programmers will be able to use this tool irrespective of language used in the data as the tool supports Unicode. The utility has two modes. One is the command-line mode that is for experienced IT administrators. However the second mode that works on scheduled basis could be useful as it need minimum baby-sitting. Even the initial setting up is made simple through an interface wizard that takes the user through the steps. The configuration is visual. Just a few clicks will help set up things. The destination database connection is tested to make sure communication is possible.
Session parameters are Saved and could be reloaded for a similar session later. The progress bar in the interface lets you monitor progress. Besides the visual progress the interface tells you how many records have been transferred. The data to be transferred to the MS SQL database could be harvested from the DB2 through queries. Multiple transfers could be initiated from the source database. Unicode compatibility means that the database records could contain text in any language. This is a very good utility that could be useful on a regular basis.