Subscribe to our news:
Frank Thomas: "The import function from Excel is brilliant! I was able to port a database from a foreign source into Excel and then import it directly into MySQL with your program".
Samuel Poole: "I recently downloaded and ordered MySQL Data Wizard, and I thought I would drop you a note to let you know that it is the software I needed . Well done, keep up the good work, and please accept my very best regards. Please feel free to use the contents of this e-mail along with my name, as an endorsement of your excellent product".
Add your opinion
Data Wizard for MySQL online help
Welcome to Data Wizard for MySQL!
Data Wizard for MySQL is a powerful toolkit for managing your MySQL data. It includes the following modules:
|•||Converts schema and data from any ADO-compatible database to MySQL.|
|•||Transfers tables, indexes, and foreign key constraints.|
|•||Migrates source objects directly to the target database or generates SQL scripts.|
|•||Imports data from the most popular formats including Excel, Access, CSV, DBF, XML, and text files to MySQL tables.|
|•||Includes Graphical Builder to map source file columns to target table fields in a few mouse clicks.|
|•||Uses bulk loading commands to speed up the import process.|
|•||Lets you to adjust data formats, empty target tables, execute custom SQL scripts, etc.|
|•||Exports data from MySQL tables, views and queries to the 17 most popular file formats including MS Excel, HTML, XML, PDF, etc.|
|•||Allows you to fully customize output files including header and footer, fonts, colors, data formats, encoding, etc.|
|•||Supports Office 2007 file formats natively.|
|•||Creates a full set of ASP.NET scripts for working with MySQL tables, views and queries through the web.|
|•||Allows to create webpages of your own style: color scheme, images, fonts, etc.|
|•||Protects generated scripts with advanced security settings.|
Other useful things
|•||State-of-the-art graphical user interface.|
Dec 6, 2013
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
Features up-to-date list of ODBC drivers / OLE DB providers and appropriate connection strings AnySQL Maestro has been examined with.
Jun 11, 2012
New version introduces SQL Dump wizard, user-defined data type mappings, auto arranging target tables by dependencies and lots of other new features.
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.
The article puts forward a scenario for implementing row level security in MySQL 5.x.
Feature of the day
Data Wizard for MySQL: Data Export allows you to export many tables at a time.
Data Wizard for MySQL provides you with Tray Agent to execute scheduled tasks without running Data Wizard.