Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Peter Robinson: "As a tech savvy company director, I wanted an inexpensive web based database application to manage all aspects of my business. As with most humans I find developing purely by CLI very hard and do not have the will or time to invest in improving my skills. I was looking to find a nice human friendly GUI to design and build my application, which is when I came across PHP Generator for MySQL.

Whilst you still need a great understanding of logic and a small amount of programming ability to get the specific results you require, I am very happy with the speed of progress I have been making with this invaluable tool.

With all the standard libraries included, this product makes normal requirements such as JavaScript form validation, lookup selectors, on click events, auto complete, detailed searches, multiformat exports, rss feeds and username security straight forward and quick.

Having any changes made via the GUI written to the web server at the click of a button makes testing out ideas quick and easy without fear of breaking your application.

To conclude, I couldn't find any other product on the market that came close to offering the amount of options this does, and I do hope that more products like this come out in the future, with the hope of eventually eradicating the need to program all together".

David Boccabella: "I am getting my manager to purchase your excellent product in a couple of day. It has really proved useful with working with the advanced features of MySQL".


Add your opinion

SQL Maestro Group / News / All company news / Data Wizards are updated to version 11.1

Data Wizards are updated to version 11.1

Jan 17, 2011

Prev Next

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

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

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).

      Connecting to ODBC data sourcePicture 1. Data Import: connecting to an ODBC data source

    • 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 restricting the transferred data by a specified criteria, limiting the number of records to be imported, and so on.

      Import of data retrieving by an SQL queryPicture 2. Import of data retrieving by an SQL query

      As usual, after adjusting the import process you can save all the settings to a template file for further using from the command line and/or on a scheduled basis.
    • Another (and for now the last) thing to note is that this kind of import completely supports BLOBs (if they are supported by the ODBC driver / OLE DB provider used).
  • The Update Existing Records option has been added to the last page of the wizard. If this option is turned ON, the records will be either updated or inserted (available for MySQL, PostgreSQL 9.0+, Microsoft SQL Server, SQLite, and Firebird 2.1+).

    Updating existing recordsPicture 3. Data Import: updating existing records

  • Now it is possible to specify SQL scripts to be executed before and/or after data import to each table. The typical example of the feature usage is the data import to several SQL Server tables with autoincrement columns. In this case you need to execute SET IDENTITY_INSERT %table_name% ON and SET IDENTITY_INSERT %table_name% OFF before and after data import to the table accordingly.
  • The log file provided by Data Import becomes more informative.

Data Pump features

  • Starting with this version it is possible to define some naming conventions for transferring metadata objects. You can choose whether source schema name will be added to target table names, select desired name case as well as specify prefix and suffix for the target tables.
  • Naming conventionsPicture 4. Naming conventions dialog

  • New version allows you to restrict number of pumped records by means of specifying filter conditions, view source table data as well as count number of records in the source tables.

Other new features

  • From now on the Data Export wizard uses a single MS Access database for all the exported tables/views/queries (doesn't create a separate database for each exported data source).
  • This release has been successfully tested with 64-bit operating systems including Windows 7 x64.

In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made. For more information about a specific tool see the appropriate page:

Prev Next