Online Documentation for Data Pump for Oracle

Version history


 

Product name

Version

Release date

Data Pump for Oracle

Version 3.1.2

March 4, 2020

Data Pump for Oracle

Version 3.1.1

March 10, 2016

Data Pump for Oracle

Version 3.1

June 20, 2011

Data Pump 2009 for Oracle

Version 3.0.0.1

February 17, 2009

Data Pump 2006 for Oracle

Version 2.2.0.1

February 21, 2007

Data Pump 2006 for Oracle

Version 2.1.0.1

June 26, 2006

 

    Version 3.1.2

 

  • Implemented support for Azure, SQL Server 2017, MySQL Server 8 and PostgreSQL 12.
  • The TRUNCATE statement is now used for deleting data from tables.
  • MySQL. The 'MySQL has gone away' error has been fixed.
  • PostgreSQL. Default values are now processed correctly.
  • The total number of records for large tables is now displayed correctly.
  • The error occured in case of using COPY statement for import. Fixed now.
  • The error occured on loading the template with columns selection in the console version. Fixed now.
  • Other fixes and improvements.

 

    Version 3.1.1

 

  • Renewed installation program containing lots of fixes.
  • Milliseconds support for the Datatime and Timestamp MySQL types.
  • The 'Out of memory' error occured on transferring a large amount of data from InterBase. Fixed now.
  • The script for the indices having the same name was generated incorrectly for SQL Server and MySQL. Fixed now.
  • Incorrect constraints refreshing in MS SQL Server with ODBC has been fixed.
  • The 'Out of memory' error occured transferring the data from DBF/FoxPro using Advantage OLE DB Provider 11. Fixed now.
  • The 'Access Violation' error occured at Step 5 of the wizard in some cases while importing data from MySQL. Fixed now.
  • There was an error while reconnecting to the source MySQL server. Fixed now.
  • Lots of other improvements and bug-fixes.

 

    Version 3.1

 

  • Added the possibility to transfer objects descriptions, if they are supported by provider.
  • 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 Oracle 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
  • Implemented support of Windows authentication for Oracle
  • 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 tunnel
  • Now the console version returns the error code (0 - successful termination, 1 - critical error, 2 – non-critical error)

 

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

Scroll to top


See also:

What's new