EMS Data Pump for DB2

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.

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. Easy-to-use wizard application allows you to build the ADO connection string, select tables, fields and indices for converting, view and edit SQL script for generating target DB2 database and select tables for import. Database conversion becomes as easy as possible with DB2 Data Pump!
Key Features:
- Unicode data support;
- Source DBMS schemas support;
- User-friendly wizard interface;
- Converting database structure and data from any SQL servers or local databases, which have an ADO provider;
- Ability to create a new database or connect to the existing one;
- Selecting source tables, fields and indices for conversion;
- Fast generation of tables, fields and indices according to the source database structure;
- Easy customization of target database objects options;
- Ability to view and edit and save SQL script for generating target database;
- Full monitoring of database generation process;
- Selecting tables and their fields for data import;
- Multilanguage support.