PostgreSQL Data Wizard 11.1.0.1

Multi-featured Windows GUI utility for managing your PostgreSQL data

PostgreSQL Data Wizard is a powerful Windows GUI utility that manages your PostgreSQL data. It provides you with a number of easy-to-use tools for performing the required data manipulation easily and quickly.

Data Pump:
Converts schema and data from any ADO-compatible database to PostgreSQL .
Transfers tables, indexes, and foreign key constraints. Migrates source objects directly to the target database or generates SQL scripts.

Data Import:
Imports data from the most popular formats including Excel, Access, CSV, DBF, XML, and text files to PostgreSQL  tables
Includes Graphical Builder to map source file columns to target table fields in a few mouse clicks.
Uses bulk loading commands to speed up the import process.
Lets you to adjust data formats, empty target tables, execute custom SQL scripts, etc.

Data Export:
Exports data from PostgreSQL  tables, views and queries to the 17 most popular file formats including MS Excel, HTML, XML, PDF, etc.
Allows you to fully customize output files including header and footer, fonts, colors, data formats, encoding, etc.
Supports Office 2007 file formats natively.

ASP.NET Generator:
Creates a full set of ASP.NET scripts for working with PostgreSQL  tables, views and queries through the web.
Allows to create webpages of your own style: color scheme, images, fonts, etc.
Protects generated scripts with advanced security settings.

Main features:

  • Data Pump: transfer any schema and data to PostgreSQL
  • Data export to as many as 18 file formats
  • Data import from Excel, CSV, text files and more
  • ASP.NET Generator: create full set of ASP.NET scripts
  • Flexible Task Scheduler
  • The Agent application to execute tasks in background mode
  • Powerful command-line interface

last updated on:
December 2nd, 2011, 22:14 GMT
file size:
7.7 MB
price:
$79.00
 
developed by:
SQL Maestro Group
license type:
Trial 
operating system(s):
Windows All
category:
C: \ Internet \ Servers \ Database Utils

In a hurry? Add it to your Download Basket!

user rating

3.6/5
 

0/5

20 Screenshots
PostgreSQL Data Wizard - PostgreSQL Data Wizard will provide users with a multi-featured Windows GUI utility for managing your PostgreSQL dataPostgreSQL Data Wizard - The Data import window will offer a list of options like Connection propertiesPostgreSQL Data Wizard - Users will be able to access options such as Connection properties or Script connection properties within the ASP.NET GeneratorPostgreSQL Data WizardPostgreSQL Data WizardPostgreSQL Data WizardPostgreSQL Data WizardPostgreSQL Data WizardPostgreSQL Data WizardPostgreSQL Data WizardPostgreSQL Data WizardPostgreSQL Data WizardPostgreSQL Data WizardPostgreSQL Data WizardPostgreSQL Data WizardPostgreSQL Data WizardPostgreSQL Data WizardPostgreSQL Data WizardPostgreSQL Data WizardPostgreSQL Data Wizard
What's New in This 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).
  • 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.
read full changelog

Add your review!

SUBMIT