Choose your database:

Partners

Customers

Become a customer

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

Download

Buy

Oracle Data Wizard online help

Table of Contents

Along with such data management abilities as data import and export, Oracle Data Wizard allows you to dump data stored in Oracle 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

Feature of the day

Templates

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

Data Pump

Oracle Data Wizard: Data Pump allows you to pump database (both of structure and data) from such sources as MS SQL or MS Access database to Oracle database.

Oracle Data Wizard online help

SQL Dump

Thanksgiving Sale