View Image

DB2 Data Wizard is a powerful Windows GUI utility for managing your DB2 data. It includes the following modules: Data Pump • Converts schema and data from any ADO-compatible database to DB2. • Transfers tables, indexes, and foreign key constraints. • Migrates source objects directly to the target database or generates SQL scripts. Data Import • Imports data from the most popular formats including Excel, Access, CSV, DBF, XML, text files, and also ODBC data sources to DB2 tables. • Includes Graphical Builder to map source file columns to target table fields in a few mouse clicks. • Uses bulk loading commands to speed up the import process. • Lets you to adjust data formats, empty target tables, execute custom SQL scripts, etc. Data Export • Exports data from DB2 tables, views and queries to the 17 most popular file formats including MS Excel, HTML, XML, PDF, etc. • Allows you to fully customize output files including header and footer, fonts, colors, data formats, encoding, etc. • Supports Office 2007 file formats natively. ASP.NET Generator • Creates a full set of ASP.NET scripts for working with DB2 tables, views and queries through the web. • Allows to create webpages of your own style: color scheme, images, fonts, etc. • Protects generated scripts with advanced security settings.