This tool is for transferring data from Oracle to DB2 databases.
OracleToDB2 is a data conversion tool that helps DBAs and database programmers to import Oracle data to DB2 database. The interface is very simple so the even the latest entrant to the IT department would be able to handle the data transfer quite easily. Besides, you could save the parameters so that anyone would be able to run transfer sessions without any hassle. The tool is easy to set up, all the setting controls are available on the main screen. The progress is indicated by a progress bar. Besides the time estimation, the progress is indicated in terms of number of records transferred successfully. Specific table to a specific table transfer is always possible. You would be able to harvest data through query. It is possible to transfer multiple tables at one time. The tool supports Unicode thus data in any language could be handled easily. All the data tables in a schema can be transferred at a time.
Wizard is able to guide transfers through batch mode. It has a command mode. However, you will need to be completely familiar with the parameters and settings required. In the scheduled mode, you can arrange to have all the data transfers that are to be done on a regular basis. Configuration details can be set up visually, making it really easy. Source schema and table can be specified and as a confirmation you could view and make sure correct data set has been specified. Same with destination table specification. If some data is to be replaced, that could be done. This is a very good tool and could be useful if these kind of transfers are to be done regularly.