Softpedia >Windows >Internet >Servers >Database Utils >PostgreSQL Data Wizard >  Changelog

PostgreSQL Data Wizard Changelog

What's new in PostgreSQL Data Wizard 11.1.0.1

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

New in PostgreSQL Data Wizard 9.12.0.1 (Dec 7, 2009)

  • Now you can import data from Microsoft Office Excel 2007 and Microsoft Office Access 2007 file formats along with Microsoft Office Excel 97-2003, Microsoft Office Access, CSV, DBF, and Text files supported in the previous versions.
  • Starting with this version you can import Text and CSV data files stored in different encodings.
  • Now it is possible to empty target tables as well as execute custom SQL scripts before and after the import.
  • An ability of using bulk-loading commands has been implemented. This feature can speed up the import process up to 10 times so it is recommended to use it always if possible.
  • The wizard has been completely redesigned to improve the look and feel and increase the usability.
  • Data Export features:
  • Support for Microsoft Office Excel 2007, Microsoft Office Word 2007, OpenDocument Spreadsheed, and OpenDocument Text file formats has been implemented.
  • Now you can select the result file encoding (ANSI, UTF8, UTF16, UTF32, OEM, and Mac).
  • The wizard also has been completely rewritten to improve the look and feel and increase the usability.
  • Datapump features:
  • The conversion rules for fields and indexes become more intelligent, so starting with this version most of source databases from well-known DBMS can be transferred even with default settings (or with a small customization). Also the speed of data transfer has been significantly increased.
  • DBMS-related features:
  • Starting with this version it is possible to connect to a remote server via SSH tunnel using a key-based authentication (in addition to the password-based authentication supported in the previous versions). To establish a remote connection in this way, you have to provide a private key (either in ssh.com or OpenSSH formats) and (optionally) a passphrase.
  • This version also introduces support for both SSH-1 and SSH-2 protocols (whereas all the previous versions supported only SSH-1).
  • Other new features:
  • An Italian localization is now included into the installation package.

New in PostgreSQL Data Wizard 8.4 (Dec 7, 2009)

  • 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 FilesSQL Maestro GroupData Wizard for MySQLmydatawizard.exe" phpgen "C:TempatesPHPGeneratorMySQLsakila.pgt" "C:TempatesPHPGeneratorMySQLsakila.log"
  • "C:Program FilesSQL Maestro GroupMS SQL Data Wizardmsdatawizard.exe" export "C:TempatesExportMsSQL
  • orthwind.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 PostgreSQL databases via HTTP tunneling has been implemented. The technology works as follows:
  • Upload the connection PHP script to your website. The scripts are named pgsql_tunnel.php 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.
  • 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 (

New in PostgreSQL Data Wizard 7.8 (Dec 7, 2009)

  • The main feature of this version is ASP.NET Generator, a powerful tool for producing ASP.NET scripts for the selected tables, views and queries for the further working with these objects through the web. Key features:
  • full customization of the HTML pages appearance with some standard HTML templates provided for your convenience;
  • full adjustment of the result script: you can enable/disable record filtering, column ordering, adding/editing/deleting records in the result script and many more;
  • advanced security options allowing you to request user name and password when someone attempts to access your script or to execute some of the specific actions: detailed viewing, adding, editing, or deleting of a table/query row;
  • filtering and sorting abilities of the result scripts;
  • automatic creation of lookup menus for foreign key constraints and custom values;
  • integrated script navigation with customization;
  • ability to create multilingual web apps.
  • New Shell Application with Ribbon toolbars (like Office 2007) and more.
  • PHP Generator: now it is possible to create a lookup menu for a column using a custom value list.
  • Data Pump: now optimized for Microsoft.Jet engine.
  • Data Import: the speed of loading of Excel files was significantly increased. All the wizards: a lot of minor improvements and corrections were made.

New in PostgreSQL Data Wizard 6.6 (Dec 7, 2009)

  • Data Wizard Task Scheduler implemented: now there is no need to perform repeated actions, just set the task (or task list) to be executed by schedule in background mode minutely, hourly, daily, weekly or monthly. You can also cease the task from executing at a specified date or after a certain number of the process repetitions; implemented a lot of security options for PHP Generator Wizard. These options allow you to request user name and password when a user attempts to access your script or to execute some of the specific actions: detailed viewing, adding, editing, or deleting of a table/query row. All the settings are available at the Security Options page;
  • added an opportunity to edit Lookup options while the web pages are being created: these features help you to customize the HTML appearance of your PosgreSQL databases for easy and efficient operating your data in the future: while working with the site you will only need to select the required names instead of entering the IDs manually; to make a comparison, you can view an example of the result page generated with lookup options applied and the one generated without lookup options;
  • several minor improvements for better code generation performed in PHP Generator;
  • improved Data Pump interface;
  • fixed a possible problem with exporting custom query result in some cases, if the query text contains characters typed in uppercase;
  • Data Export Wizard now determines column size for custom queries correctly (fixed after a bug report);
  • fixed some minor bugs.

New in PostgreSQL Data Wizard 6.5 (Dec 7, 2009)

  • PostgreSQL Data Wizard provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. It allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to the PostgreSQL database with its structure and data, export data from PostgreSQL tables and queries to most popular formats and import data into the tables.
  • Product release versions are formalized according to temporal principles: the first figure of the product version stands for the year of release; the second figure of the version is meant to indicate the month of the current version release. Hence the present version is 6.5.
  • While developing the new software product we tried to implement the usable features available in the existing products and provide it with unique functionality. Please consider the short list of PostgreSQL Data Wizard 6.5 main features below:
  • powerful PHP Generator for creating PHP scripts from PostgreSQL tables and queries from different databases; full customization of the result HTML appearance with some standard HTML templates provided for your convenience; full customization of the result script: you can enable/disable record filtering, column ordering, adding/editing/deleting records in the result script and many more;
  • Data Pump Wizard implementation: you can convert any local or remote ADO-compatible database with its structure and data to your PostgreSQL database in a few mouse clicks; full customization of the target database and objects: you can create a new database or convert it 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 with the ability of viewing and editing the SQL script generated for the database conversion;
  • easy data export operations: PostgreSQL Data Wizard 6.5 provides a powerful tool for exporting data from PostgreSQL tables and queries 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 to different databases with an ability to select fields to be included into the result files and full customization of the result export files: formats, headers/footers, record count, etc. and powerful options for specific customization: full Excel formatting including notes and hyperlinks, RTF formatting, full HTML and PDF appearance adjustment, and more;
  • efficient tools for importing data: PostgreSQL Data Wizard 6.5 provides a powerful tool for importing data into PostgreSQL tables from different databases with 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 and 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;
  • the Shell Application that provides friendly user interface for working with all the implemented wizards: easy-to-use interface provided by the PostgreSQL Data Wizard will make your work with PostgreSQL data fast and highly efficient;