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

Subscribe to our news:
Partners
Testimonials
David Lantz: "Thank you, this is by far the simplest, and most friendly utility for building db record system I have ever used. I wish I could get my systems guys at the office to purchase this for our company would be so very helpful and speed up a lot of work. I for one have used it for everything from a simple inventory record of my house, to a members record for my church just little pet projects and a test bed to test my own db builds and theories before having to hand code at the office..... it is a lot of fun to work with".
Josh Armstrong: "I absolutely love this software! It will me take our migration time down by an order of magnitude. It has especially helped with my indexing as my database contains many complex ones".

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