Subscribe to our newsletter
 Partners
Testimonials
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".
Jeff Johnson: "Thanks for your help. I'm a big fan of your software. It's very useful".
More
Add your opinion
Customers
|
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. |
|
Company news 
Dec 1, 2009
Completely redesigned Data Import and Data Export wizards, support for the SSH-2 protocol, Italian translation, and more.
Jun 22, 2009
The article provides you with a step-by-step solution of the problem based only on built-in MySQL features.
Apr 30, 2008
New version features support for system tasks, command line options, a lot of improvements in PHP Generator and much more.
Resources
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 Pump allows you to convert databases (structure and data) from such sources as SQL Server, Oracle, PostgreSQL, MS Access and others to MySQL.
Data Wizard for MySQL: Data Export allows you to export many tables at a time.
|
