Data Wizard product family updated to version 8.4

Apr 30, 2008

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.
  
  

• Data Wizard for MySQL
  
• MS SQL Data Wizard
  
• PostgreSQL Data Wizard
  
• Oracle Data Wizard
  
• SQLite Data Wizard
  
• Firebird Data Wizard
  
• MaxDB Data Wizard
  

Back to news archive