Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Simon Pills: "Someone finally invented an intuitively used and easily customized PostgreSQL database administration tool! Keep up the good work. I will be in touch. I am able to do this horrendous work because your software enabled me to create a new database with all necessary objects in several minutes! I am sure that I have found what I really need".
Richard Finner: "Thanks. I have paid my money. I experimented with many trial copies of similar programs and found your SQLite Data Wizard to be ingenious yet simple. It suits my working style".

More

Add your opinion

SQL Maestro Group / News / All company news / New version of Data Wizard product family

Data Wizard product family updated to version 8.4

Apr 30, 2008

Prev Next

SQL Maestro Group is happy to announce the release of Data Wizard 8.4, a toolset of powerful utilities for managing your data. There are versions for MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite, Firebird and MaxDB.

Please consider the list of new features implemented in this version since last official release:


Common improvements:

  • Now it is possible to create a system scheduled task or convert a task created in Data wizard to system one. Such tasks can be executed by the Windows scheduler service even without user logon.

  • Command line options are implemented. The syntax is as follows:

    datawizard_executable[.exe] task_type template_file_name [log_file_name]

    where task_type can be one of the following:

    aspnetgen ASP.NET Generator Task
    datapump Data Pump
    export Data Export Task
    import Data Import Task
    phpgen PHP Generator Task


    Examples:

    • "C:\Program Files\SQL Maestro Group\Data Wizard for MySQL\mydatawizard.exe" phpgen "C:\Tempates\PHPGenerator\MySQL\sakila.pgt" "C:\Tempates\PHPGenerator\MySQL\sakila.log"

    • "C:\Program Files\SQL Maestro Group\MS SQL Data Wizard\msdatawizard.exe" export "C:\Tempates\Export\MsSQL\northwind.ext"

  • Since this version each task is displayed as a separated icon in the system tray when executing.

DBMS-related features:

  • A possibility of connecting to remote MySQL, PostgreSQL and SQLite databases via HTTP tunneling has been implemented. The technology works as follows:

    • Upload the connection PHP script to your website. The scripts are named mysql_tunnel.php, pgsql_tunnel.php and sqlite_tunnel.php for MySQL, PostgreSQL and SQLite accordingly and can be found under the corresponding installation folder.

    • Test the script in your web-browser (optionally).

    • Enter the script URL in the corresponding edit field at the first step of a wizard. Of course you should turn ON the "I have to use HTTP tunneling" option.

  • Oracle Data Wizard now supports all the Oracle database server versions from 8i to 11g.

PHP Generator features:

  • Since this version it is possible to specify different connection parameters for the database server and generated PHP scripts.

  • An ability of building UTF-8 web applications has been added.

  • BLOB fields now can be represented as pictures. It is also possible to add, edit and delete the images directly from the generated web application.

  • Starting with this version our software allows you to create web-pages with hyperlinks. The result links are constructed as follows: Prefix + contents of HREF field + Suffix. The Target attribute can be customized too.

  • PHP Generator now supports creation of look up menus based on a custom value list. For ENUM fields such list is created automatically.

  • The View, Edit, and Delete command links are now placed at the left of data columns by default.

  • The wizard window becomes resizable. Also it can be maximized or minimized.

  • Now our software generates classic PHP opening tags (<?php) instead of short ones (<?).

Other new features:

  • Data Pump: now you can execute custom SQL scripts after connecting, before data importing and after pumping.

  • ASP.NET generator: since this version it is possible to specify a custom connection string.

  • All the wizards: a lot of minor improvements and corrections were made.

For more information about a specific tool see the appropriate page:
     
Prev Next