Subscribe to our news:
Jeff Johnson: "Thanks for your help. I'm a big fan of your software. It's very useful".
Piter Jason: "I wanted to take this opportunity to thank SQL Maestro Group for providing me the tools to succeed. I have no doubt that without them I would have failed to do my job. I am proud that I have suceeded. Thank you".
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 allows you to schedule tasks for executing them (once or periodically) later.
Data Wizard for MySQL: Data Pump allows you to convert databases (structure and data) from such sources as SQL Server, Oracle, PostgreSQL, MS Access and others to MySQL.