PostgreSQL Migration Toolkit Releases
Released: Nov 21, 2022
Updates in v5.3
Features
- Microsoft Access to PostgreSQL: Improved support for calculated and attachment columns.
- Firebird to PostgreSQL: Added support for views and improved processing of default values.
- PostgreSQL to Microsoft SQL: Sequences are now migrated.
- SSL connection for PostgreSQL is now supported.
- Added the option to select source and target schema in Microsoft SQL Server to PostgreSQL and Oracle to PostgreSQL.
- Improved migration of spatial data in SQL Server to PostgreSQL and MySQL to PostgreSQL.
Released: Oct 18, 2021
Updates in v5.1
Features
- Added a new PostgreSQL-to-Excel tool which allows you to publish PostgreSQL databases as Excel spreadsheets.
- Microsoft Access to PostgreSQL: Improved processing queries.
- Improved Microsoft SQL Server to PostreSQL and PostgreSQL to SQL Server conversion with support for sequences.
- Added intelligent validation of privileges on source and target databases.
Released: Mar 15, 2021
Updates in v4.5
Features
- Added support for latest PostgreSQL authentication protocol.
- Added 64-bit version.
Released: May 18, 2020
Updates in v4.3
Features
- MS Access to PostgreSQL does not require MS Access/Office installation.
- SQL Server to PostgreSQL, Oracle to PostgreSQL, MySQL to PostgreSQL with options to select PostrgreSQL encoding, create table LOGGED/UNLOGGED, INSERT/COPY method.
- SQLite to PostgreSQL: options to select PostrgreSQL encoding.
Fixes
- DB2 to PostgreSQL: misc fixes, log file in GUI.
- FoxPro to PostgreSQL: fix on dates processing.
- PostgreSQL to MS SQL: improved conversion of datetime and timestamp with time zone, fix for...
Released: Nov 25, 2019
Updates in v4.1
Features
- Added support for PostgreSQL v12.
- Added new tool DB2-to-PostgreSQL.
Released: Jun 24, 2019
Updates in v3.5
Features
- pgs2sql: table customization (option to modify name, type and other attributres of any table column).
- sql2pgs: option to specify PostgreSQL schema and improved foreign keys creation.
Fixes
- ora2pgs: fixed COPY-statement for compound table names.
Released: Jun 11, 2018
Updates in v3.3
Features
- piecewise writing to PostgreSQL script file (large BLOBs support).
- mss2pgs: improved support for def.values for datetime columns + views reorder.
- pgs2mss: support for views, piecewise writing to T-SQL script.
- pgs2ora: support for views.
- slt2pgs: improved type mapping for boolean, decimal, datetime.
Released: Dec 11, 2017
Updates in 3.1
Features
- New converters acc2pgs, fbr2pgs and slt2pgs have been added.
- Support for Oracle v12.2 and Unicode in ora2pgs and pgs2ora.