Online Documentation for Data Pump for Oracle

Version history

    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