What is EMS Data Pump for DB2?
EMS Data Pump for DB2 is an excellent migration tool for converting databases and importing table data from an ADO-compliant source (for example, MS Access, MS SQL database, or any other ADO-supported database) into IBM DB2 databases. The easy-to-use wizard application lets you create the ADO connection string, select tables, fields, and indexes to convert, view, and edit the SQL script to generate the target DB2 database, and completely customize the import process. Data Pump for DB2 has the ability to automate the migration to the DB2 server task using the useful console utility. With Data Pump for DB2, converting and migrating the database to DB2 becomes as easy as possible!
Core features
- Friendly wizard interface.
- Converting structure and data from any local and remote data source with an ADO provider.
- Unicode media.
- Selecting schemas, tables, fields, and source indexes for conversion.
- Quick generation of tables, fields, and indexes according to the structure of the source database.
- Easily customizable options for target database objects.
- Ability to view/edit, run and save SQL scripts to generate the target database structure.
- Selecting tables and defining criteria for data import.
- Complete monitoring of the pumping process.
- Ability to save all parameters specified in the current wizard session as a template.
- Multilingual GUI (Graphical User Interface) support.
- Command-line utility to automate data pump work with the help of a model file.
- Ability to specify schema for target database tables.
System Requirements
- 300 MHz processor; Recommended 600 MHz (MHz) processor
- Microsoft Windows NT4 com SP4 ou posterior, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows 2008 Server, Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows 8, Microsoft Windows 8.1, Microsoft Windows 10
- 64 MB of RAM or more; 128 MB or more recommended
- 20 MB of available HD space for program installation
- Super VGA (800x600) or higher resolution video adapter and monitor; Super VGA (1024x768) or higher resolution video adapter and monitor is recommended
- Microsoft mouse or compatible pointing device
- DB2 Run-Time / Administrative Client 8.0 ou superior
- IBM DB2 Connect (no case of using servers gives platform z / Series, iSeries, pSeries)
