PostgreSQL Data Wizard 126.96.36.199
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.
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.
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.
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.
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.
- 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
In a hurry? Add it to your Download Basket!
- 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.