Share via

Preview release of SQL Server Migration Assistant (SSMA) for SQL Server 2016 RC0

  • Article

Microsoft has released a preview release of SQL Server Migration Assistant (SSMA) that supports migrating databases from Oracle, Sybase ASE, DB2, MySQL and Access to SQL Server 2016 Release Candidate 0. In this release, the following features have been added:

SSMA 6.1 Preview, all platforms:

  • Support for SQL Server 2016 Release Candidate 0
  • Support for running SSMA on Windows 10

SSMA 6.1 Preview for Oracle now supports Row Level Security including the following:

  • Support loading of security policies from the Oracle Virtual Private Database (VPD)
  • The Oracle VPD is represented in the SSMA UI with policy objects underneath
  • The associated VPD attributes and predicate function are represented in the SSMA UI
  • Support loading of security policies from SQL Server 2016
  • SQL Server Security policies are represented in the SSMA UI and organized in categories
  • The SQL Server Security policies associated attributes are represented in the SSMA UI
  • Support for conversion of Oracle security policies to SQL Server security policies

SSMA 6.1 Preview for Oracle now supports In-Memory Tables and Column Store including the following:

  • Support loading of in-memory tables shown in UI with 'M' icon
  • Support conversion to selected SQL Server mapping:
    • Row-store table with Non-clustered Columnstore Index
    • In-memory OLTP tables
    • Clustered Columnstore Index-organized table
    • Row-store table without Columnstore Indexes

To download the SSMA 6.1 Preview release see the following links:

Comments

  • Anonymous
    April 06, 2016
    Did you guys even test this before it left the factory ? The Extension pack is still trying to use TRIPLE_DES for the password security which is a deprecated feature in SQL 2016 ! I assume as part of the install script its doing something like this CREATE SYMMETRIC KEY TestTableKeyWITH ALGORITHM = TRIPLE_DES ENCRYPTIONBY CERTIFICATE EncryptTestCertPlease test the extension pack and make sure compatibility mode is 130 !
  • Anonymous
    April 28, 2016
    The comment has been removed
  • Anonymous
    June 03, 2016
    when will be the final version released??