EMS Data Pump for DB2 is a powerful utility for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MS SQL Server, or any other database with ADO support) to IBM DB2 databases.
Features: EMS Data Pump for DB2 lets you import data from ADO compatible sources. Such sources include MS Access, MS SQL Server, or any other databases. The easy to use wizard lets you set up an ADO connection string, select tables, fields, and indices. Items that you need for converting, viewing and editing SQL script and generating target DB2 database and select tables for import. Database conversion becomes as easy as joining the dots by clicking through the DB2 pump. Data Pump for DB2 has the ability to automate migration to DB2 server task using the helpful console utility. Source DBMS schemes supported. You are able to support Unicode data. Converting database structure and data from any SQL servers or local databases is possible.
While converting is easy it is equally easy to create a new one altogether. You can do selective conversions too such as selecting source tables, fields and induces rather than the whole database. Target database objects can be easily customized. You can select tables and the fields you want to import data to. The application gives you the abilities to view, edit and save SQL scripts for generating a target database. The generation process can be fully monitored. Multilanguage support provided. You can save all the settings of the current session as a template so that similar sessions in future can be carried out easily.
Overall: A useful utility if you have a lot of work with DB2.