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