SQL Maestro Group / Products / MySQL / Data Wizard for MySQL / Documentation

Data Wizard for MySQL online help

Welcome to Data Wizard for MySQL!

Data Wizard for MySQL is a powerful tool for managing your MySQL data. It provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. Data Wizard for MySQL allows you to generate ASP.NET and PHP scripts for the selected tables and queries, convert any ADO-compatible database to the MySQL database with its structure and data, export data from MySQL tables and queries to most popular formats, and import data into the tables.

Basic Data Wizard for MySQL features

ASP.NET Generator

•	Generating ASP.NET scripts for working with MySQL tables, views and queries.

•	Full customization of the result HTML appearance with some standard HTML templates provided for your convenience.

•	Full customization of the result script: you can enable/disable record filtering, column ordering, adding/editing/deleting records in the result script and many more.

•	Protection of your ASP.NET scripts with optional security settings.

PHP Generator

•	Generating PHP scripts for working with MySQL tables and queries from different databases.

•	Full customization of the result HTML appearance with some standard HTML templates provided for your convenience.

•	Full customization of the result script: you can enable/disable record filtering, column ordering, adding/editing/deleting records in the result script and many more.

•	Protection of your scripts with optional security settings.

Data Pump

•	Converting any local or remote ADO-compatible database with its structure and data.

•	Full customization of the target database and objects: you can create a new database or convert to the existing one, select objects for conversion and adjust their properties for the target database. Adjustable data import from the source tables to the target ones.

•	The ability of viewing and editing the SQL script generated for the database conversion.

Data Export

•	Data export from MySQL tables and queries to different databases.

•	The ability to export data to any of the 14 available formats: MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, TXT, DBF, CSV, SYLK, DIF, LaTeX and SQL.

•	Selecting fields to be included into the result files.

•	Full customization of the result export files: formats, headers/footers, record count, etc.

•	Powerful options for specific customization: full Excel formatting including notes and hyperlinks, RTF formatting, full HTML and PDF appearance adjustment, and more.

Data Import

•	Data import into MySQL tables from different databases.

•	The ability to import data from the following available formats: MS Excel, MS Access, XML, DBF, TXT and CSV.

•	Easy adjustments of the source file columns and the destination table fields.

•	Full customization of the import process for each imported file including data formats for all or selected fields, commit options, number of rows to skip and records to import, etc.

•	The ability to define the key columns for the table and select whether to skip, update or delete the records if their keys value match the imported ones.

Return to chapter overview