PostgreSQL Migration Toolkit のリリース

Released: Nov 21, 2022

v5.3 での更新項目

機能

  • 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

v5.1 での更新項目

機能

  • 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

v4.5 での更新項目

機能

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

Released: May 18, 2020

v4.3 での更新項目

機能

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

不具合の修正

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

Released: Nov 25, 2019

v4.1 での更新項目

機能

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

Released: Jun 24, 2019

v3.5 での更新項目

機能

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

不具合の修正

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

Released: Jun 11, 2018

v3.3 での更新項目

機能

  • 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

3.1 での更新項目

機能

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