EMS DB Extract for DB2

EMS DB Extract for DB2 is an utility for creating database backups in the form of SQL scripts. It allows you to save metadata of all database objects as well as table data.

Features: EMS DB Extract for DB2 is a tool for creating backups of databases. This is done in the form of SQL scripts. You are able to save meta-data of all database objects as well as table data. Customization options are quite flexible so that you can select objects for the extraction process. There’s a graphical wizard that helps users step through the extraction process. There is a command-line service for experienced users to create one touch for creating backups. You are given option of selecting objects to backup. If necessary, you can define constraints for extracted table data. It is flexible enough to let you insert statements that`ll empty the tables before inserting extracted data.

Table data can be extracted by SQL scripts as Insert commands. Possibilities are offered to be able to extract database objects in correct order based on their dependencies. Result scripts can be compressed and split into volumes. You could select the charset for the result file. The ability to save all extraction parameters in a session gives you the ability to use the configuration in future sessions in a similar situation. For the experts there`s command line utility for extracting meta-data and data by using configuration files. Unicode is supported so that supporting multi-language data is not difficult at all.

Overall: A neat tool for back up.

EMS DB Extract for DB2 is a powerful and easy-to-use utility for creating database backups in a form of SQL scripts. It allows you to save metadata of all database objects as well as table data. With flexible customization of the extract process you can select objects and data tables for extract and tune many other extract options. DB2 Extract includes a graphical wizard, guiding you through the extract process step by step, and a command-line service for creating backups in one-touch.
Key Features:
Support of Unicode data
User-friendly wizard interface
Selecting database objects for extraction
Possibility to define constraints for extracted table data
Possibility to insert statements for emptying tables before inserting extracted data
Extracting table data to SQL script as INSERT statements
Possibility to extract database objects in the correct order according to their dependencies
Possibility to compress the result script and split it into volumes
Possibility to select charset for the result file
Saving all extraction parameters set on the current wizard session
Command-line utility to extract metadata and data using the configuration file