Choose your SQL server:

Partners

Testimonials

Edward Littel: "MS SQL Data Wizard has been great for managing our Microsoft SQL data. I recommend the software highly".

Alex Freeze: "Good job! As always, MS SQL Data Wizard is at the front of my list with regards to when we advise a simple and powerful Microsoft SQL data manager".

Add your opinion

Customers

Become a customer

SQL Maestro Group / Products / MS SQL Server / MS SQL Data Wizard / Documentation

Download Buy

MS SQL Data Wizard online Help

Table of Contents

Data Pump

Data Pump wizard is a powerful tool for converting structure and data from any ADO-compatible source (e.g. MS Access or MS SQL database) to Microsoft SQL databases. It allows you to transfer tables, indexes, and foreign key constraints. With the wizard you can convert source objects directly to the target database or generate SQL scripts with objects definitions and INSERT statements. To run the wizard, use the Run Data Pump Wizard link at Home page.

To convert a database with its structure and data,

•	Set connection properties of source and target databases;

•	Select objects to convert;

•	Adjust options of the objects to create;

•	Select tables for data import;

•	Specify other transfer options.

See also: Templates, Data Pump Options.

Table of Contents

Company news

Dec 1, 2009

Data Wizard product family advanced to version 9.12

Completely redesigned Data Import and Data Export wizards, support for the SSH-2 protocol, Italian translation, and more.

Apr 30, 2008

Data Wizard product family updated to version 8.4

New version features support for system tasks, command line options, a lot of improvements in PHP Generator and much more.

Aug 22, 2007

New version of Data Wizard product family released

Features ASP.NET Generator wizard and a new Shell Application with the Ribbon toolbar. There are versions for MySQL, Oracle, SQL Server, PostgreSQL, SQLite, Firebird and MaxDB.

More news

Resources

A brief guide to connection strings for AnySQL Maestro

The article contains a list of ODBC drivers and OLE DB providers the software has been examined with. The corresponding connection strings are also included.

More resources

Feature of the day

Task Scheduler

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

Data Pump

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