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 wishes you a happy Thanksgiving!

We are pleased to grant you a 20% discount for all our products and bundles till the end of November!

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

Data Import

DB2 Data Wizard: Data Import allows you to import data from several sources in one attempt.

Templates

Each wizard included in DB2 Data Wizard allows you to save its current settings as a template for future use.

DB2 Data Wizard online Help

SQL Dump

Thanksgiving Sale