Lanzamientos de PostgreSQL Migration Toolkit

Released: May 26, 2025

Actualizaciones en v5.5

Características

  • Added support for the latest PostgreSQL authentication protocol.
  • Improved performance of multi-threading algorithm for migration in 'mss2pgs' and 'sql2pgs'.
  • Spatial data (geometry, point) is now migrated by 'pgs2mss'.
  • Improved support for fixed width char in 'mss2pgs'.

Correcciones

  • Fixed custom schema in foreign key statements in 'mss2pgs' and 'ora2pgs'.

Released: Nov 21, 2022

Actualizaciones en v5.3

Características

  • 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...

Released: Oct 18, 2021

Actualizaciones en v5.1

Características

  • 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

Actualizaciones en v4.5

Características

  • Added support for latest PostgreSQL authentication protocol.
  • Added 64-bit version.

Released: May 18, 2020

Actualizaciones en v4.3

Características

  • 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.

Correcciones

  • 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...

Released: Nov 25, 2019

Actualizaciones en v4.1

Características

  • Added support for PostgreSQL v12.
  • Added new tool DB2-to-PostgreSQL.

Released: Jun 24, 2019

Actualizaciones en v3.5

Características

  • 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.

Correcciones

  • ora2pgs: fixed COPY-statement for compound table names.

Released: Jun 11, 2018

Actualizaciones en v3.3

Características

  • 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

Actualizaciones en 3.1

Características

  • New converters acc2pgs, fbr2pgs and slt2pgs have been added.
  • Support for Oracle v12.2 and Unicode in ora2pgs and pgs2ora.