Release: AWS Schema Conversion Tool on 2016-01-14

This release includes functional improvements and bug fixes.

Release Date: January 14, 2016
Latest Version: 1.0.200
Created On: January 14, 2016
Last Updated: October 09, 2017

New Features

Feature Description
Maintenance Update Includes functional improvements and bug fixes:
  • Adds support for the PostgreSQL database engine as a target when converting from Oracle and SQL Server source databases.
  • Adds the ability to save converted schema as SQL scripts in local files before applying the converted schema to the target DB instance.
  • Updates the database migration assessment report with new categories for time estimates of how long it will take to manually convert schema items that could not be automatically converted. The categories are the following:
    • Simple – less than 1 hour
    • Medium – 1 to 4 hours
    • Significant – more than 4 hours
    For more information, see Creating and Using the Assessment Report.
  • Schema items that could not be automatically converted to the target DB instance are now highlighted in the tool with an exclamation point icon.
  • The Oracle TRUNC function is now converted to the MySQL TRUNCATE function for MySQL and Amazon Aurora target DB instances.
  • The Microsoft SQL Server PARSENAME, ISNUMERIC, and CAST functions are now supported.
  • For the SQL Server DATEADD function, the millisecond date part is now supported.
For more information, go to Getting Started with the AWS Schema Conversion Tool.