MySQL Data Wizard description
|
A Windows GUI utility for MySQL data management and PHP programming
Data Wizard for MySQL is a very useful toolkit for managing your MySQL data. It includes the following modules:
Data Pump:
· 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.
Data Import:
· 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.
Data Export:
· 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.
ASP.NET Generator:
· 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:
· Flexible task scheduler.
· Easy-to-use templates.
· Powerful command line tools.
· State-of-the-art graphical user interface. Here are some key features of "MySQL Data Wizard":
ASP.NET Generator:
· Data Wizard for MySQL provides you with a tool to create ASP.NET scripts for working with MySQL tables, views and queries. The utility allows you to customize the result HTML appearance and the result script. You can enable/disable record filtering, column ordering, adding/editing/deleting records in the result script and more. The result ASP.NET scripts may be protected with password system.
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.
· Full customization according to your preferences and needs
· You can customize the software behavior, select a user interface scheme and set a lot of other preferences.
Requirements:
· Pentium PC or higher
· 64 MB RAM (128 MB recommended);
· 10 MB of free hard disk space;
· SVGA-compatible video adapter;
· MySQL server version from 3.23 to 6.0.
· Internet Explorer 4.0 or higher.
Limitations:
· 30 day trial What's New in This Release: [ read full changelog ]
Data Import features:
Starting with this version it becomes possible to import data from any database accessible via an ODBC driver or OLE DB provider, such as SQL Server, MySQL, Oracle, MS Access, Sybase, DB2, PostgreSQL, etc. Let's look through some details of the new feature:
· To import data in this way, you have to specify a connection string and select appropriate identifier quote characters to escape improper symbols and blanks in object names according to the source database (for example, double quotes for Oracle and PostgreSQL, backticks for MySQL, or square brackets for SQL Server and MS Access).
· This type of data import does not require the structure of source database to be identical with the structure of the target one. For example, data from a single source table can be imported to several different target tables and vice versa. This becomes possible because of an ability of using custom SQL queries as import data sources. Other benefits of this feature include restr...
|
|
 | | Softpedia guarantees that MySQL Data Wizard 11.1.0.1 is 100% CLEAN, which means it does not contain any form of malware, including spyware, viruses, trojans and backdoors. [read more >] |
|
Find us on Google+
Part of the 
