Choose your database:

Partners

Customers

Become a customer

SQL Maestro Group / Products / DB2 / DB2 Data Wizard / Documentation

Download

Buy

DB2 Data Wizard online Help

Table of Contents

Along with such data management abilities as data import and export, DB2 Data Wizard allows you to dump data stored in DB2 tables and views. As the result of the SQL Dump wizard activity you'll get a bunch of .sql files (each table or view is dumped to a separate file) containing SQL statements to create a table and populate it. To run the wizard, use the corresponding link at the Home page.

To get SQL dump, complete the following steps:

•	Set connection properties of the database with tables to be dumped;

•	Select objects to dump;

•	Set destination files;

•	Specify common SQL dump options.

See also: Templates

Table of Contents

SQL Maestro Group wish you a Merry Christmas!

We're happy to grant you a 20% discount for all our products and bundles till December 31!

Company news

Feb 11, 2016

Data Wizards are updated to version 16.2

New version features two new wizards for unloading and loading BLOB data, updated Data Import tools, command-line builders for all the wizards as well as some other new features.

Dec 6, 2013

Data Wizards advanced to version 13.12

New version features updated Data Import and SQL Dump tools, data export to JSON format, redesigned Start Page, and some other useful things.

Feb 11, 2013

The Connection String Reference has been updated

Features up-to-date list of ODBC drivers / OLE DB providers and appropriate connection strings AnySQL Maestro has been examined with.

More news

Resources

How to add inline buttons to a webpage created with PHP Generator?

The article shows how to implement an AJAX-based one-click editor for a logical column.

Investigating NBA demo. Part 1: Customizing common templates

This article begins a series of step-by-step tutorials on how we made the NBA demo. It explains how to add new items to the menu, implement run-time theme selection, and tweak the login form.

How to add a chart to a webpage created with PHP Generator?

The article illustrates how to use various chart libraries with PHP Generator.

More resources

Feature of the day

Background Mode

DB2 Data Wizard allows you to execute its wizards in background mode with previously saved template.

Task Scheduler

DB2 Data Wizard has an ability to schedule tasks for executing them (once or periodically) later.

DB2 Data Wizard online Help

SQL Dump

Christmas Sale