EMS logo

Products Navigation

Data Pump for PostgreSQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Data Pump for PostgreSQL

On-line Documentation

Version history


 

Product name

Version

Release date

Data Pump for PostgreSQL for PostgreSQL

Version 3.1

June 20, 2011

Data Pump 2009 for PostgreSQL

Version 3.0.0.1

February 17, 2009

Data Pump 2006 for PostgreSQL

Version 2.2.0.1

February 21, 2007

Data Pump 2006 for PostgreSQL

Version 2.1.0.1

June 26, 2006

Data Pump 2006 for PostgreSQL

Version 2.0.0.1

March 13, 2006

PostgreSQL Data Pump

Version 1.6.0.1

March 8, 2005

PostgreSQL Data Pump

Version 1.4.0.1

March 25, 2004

PostgreSQL Data Pump

Version 1.0.0.1

February 2, 2003

 

Full version history is available at http://www.sqlmanager.net/products/postgresql/datapump/news

 

 

     Version 3.1

 

  • Added the possibility to transfer objects descriptions, if they are supported by provider.
  • Added the option allowing to set sequence options after data importing.
  • It is now possible to transfer views/queries data.
  • Added the possibility to refresh the objects tree of source database.
  • Now when importing data, foreign keys are disabled and recreated automatically.
  • Support of the latest Server versions is implemented.
  • Some other improvements and bugfixes.

 

 

Version 3.0

 

  • Implemented Unicode data support
  • Source DBMS schemas support has been implemented
  • Added an option allowing one to enable/disable refreshing of source objects on connection
  • Added an option specifying whether all source tables are selected by default at Step 3
  • Quoting identifiers for the source database can be customized at Step 4 now
  • Pumping BLOB fields using ODBC drivers v5.1 for MySQL was not possible. Fixed now
  • Latest versions of target PostgreSQL DBMS are supported
  • Improved schema support for target database
  • It is now possible to clear tables before importing data
  • It is now possible to generate DROP TABLE statements
  • Using OIDs for pumped objects is now optional
  • The wizard window is now resizable
  • The possibility to restart the wizard is added at the last step
  • It is now possible to specify the wizard step that will be opened after loading a template
  • It is now possible to start data import after loading a template
  • Implemented password encryption in templates and registry
  • A number of minor bug-fixes and visual improvements

Scroll to top

 

Version 2.2

 

  • It is now possible to enforce quoting for object names in the result script for data import automatically (when applied to "unrecognized" OLE DB/ODBC providers)
  • Implemented Private Key support for SSH authentication
  • Added the ability to specify the default schema for tables import
  • Added French and German interface localizations for the utility
  • A number of minor bug-fixes and visual improvements

Scroll to top

 

Version 2.1

 

  • Two types of template formats have been implemented: the fixed one which points to a certain list of objects to be transferred, and the dynamic one which defines only excluded objects; the objects out of this list are to be transferred. Template files of old format are still supported
  • Added the opportunity to connect through the SSH or HTTP tunnel
  • The 'Recreate database' option is implemented in the GUI version of the utility: the options allows you to delete the existing database before creating a new one (this option has been only in the console version until now)
  • Now the console version returns the error code (0 - successful termination, 1 - critical error, 2 – non-critical error)
  • Added an option allowing one to specify whether the COPY statement is to be used instead of the INSERT INTO statement for data import to increase the transfer speed considerably

Scroll to top

 

Version 2.0

 

  • New top-of-the-art user interface
  • Full support of the latest database server versions
  • New and advanced options
  • Multi-language support
  • A lot of other improvements and bug-fixes

Scroll to top

 

Version 1.6

 

  • Fixed the "Floating point division by zero" error that arose in some particular cases
  • PostgreSQL 8.x support
  • Fixed a bug which occurred in the process of converting DATETIME fields
  • Corrected the maximal length of identifiers: 128 for table names, 30 - for fields and 18 for index (instead of 18 for all)
  • In case of reading TEXT type fields through MySQL ODBC Driver they showed as empty - fixed now
  • Some minor visual improvements and bug-fixes

Scroll to top

 

Version 1.4

 

  • Implemented Global Type Mapping: now it is possible to set the correspondence between types of the source and the target databases
  • The utility now shows the import progress indicator for tables and table records; average import speed is also displayed
  • Now the program correctly recognizes schemas for Oracle data sources
  • Data Pump now supports PostgreSQL 7.4

Version 1.0

 

Basic features:

  • Converting database structure and data from any SQL servers or local databases which have an ADO provider
  • Ability to create a new PostgreSQL database or connect to the existing one
  • Possibility of selecting source tables, fields and indices for conversion
  • Easy and customizable generation of PostgreSQL tables, fields and indices according to the source database structure
  • Ability to view, edit and save SQL script for generating target database to a file
  • Full monitoring of the generation process
  • Possibility of selecting tables for data import
  • Friendly graphical user interface
  • The command-line utility to generate data using the template file

and more...

Scroll to top

 


See also:

What's new