MS SQL Migration Toolkit Releases

Released: Mar 15, 2021

Updates in v7.1

Features

  • MSSQL-to-PostgreSQL: support for latest PostgreSQL authentication protocol, sequences are migrated now.
  • MySQL-to-MSSQL: improved support for Unicode.
  • 64-bit version is available.

Released: Sep 28, 2020

Updates in v6.5

Features

  • Access-to-MSSQL: MS Access is not required anymore.
  • SQL Server to PostgreSQL converter: option to create PostgreSQL tables logged/unlogged.
  • SQL Server to PostgreSQL converter: option to switch between INSERT/COPY when writing into PostgreSQL database.
  • SQLite-to-MSSQL: option to export data into T-SQL script file.

Released: Apr 22, 2019

Updates in v6.3

Features

  • Adds new tool DB2-to-MSSQL - migrates IBM DB2 databases to SQL Server or Azure SQL. (All versions of IBM DB2 are supported.)
  • Adds support for 4Gb+ rows in Oracle-to-MSSQL.

Fixes

  • Fixes in MSSQL-to-PostgreSQL v4.1
    • Fixed - error 'zero-length delimited identifier' has been fixed in foreign keys statements.
    • Fixed - statement SELECT (datediff_day($1, $2) * 24 + date_part('hour', $2 ... has been fixed in 'functions for views'.
  • Fixes in MSSQL-to-Oracle v6.1
    • Fixed - conversion of NVARCHAR(4000).

Released: Jun 19, 2017

Updates in 5.5

Features

  • Improved support for Microsoft Azure.
  • Support for views in mss2pgs and ora2mss.
  • Use VARCHAR(MAX) and VARBINARY(MAX) instead of TEXT and IMAGE in all ...2mss tools.
  • Option to connect to non-default PGS database in mss2pgs and pgs2mss.
  • Synchronization and user defined log-file in GUI version in ora2mss.
  • Option to export PostgreSQL database into T-SQL script in pgs2mss.
  • User-defined log file in GUI version and support for date_format() function in sql2mss.