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


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 (4)

  1. Chris says:

    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 TestTableKey
    WITH ALGORITHM = TRIPLE_DES ENCRYPTION
    BY CERTIFICATE EncryptTestCert

    Please test the extension pack and make sure compatibility mode is 130 !

  2. JunKawano says:

    SSMA for Oracle Script Installer fails when I click Next in the "Enter a password for extension pack database master key." window. The environment I setting up is Windows Server 2016 TP5 on Azure + SQL Server 2016 RC3(Additionally, I installed .Net Framework 3.5 Feature from Windows Server 2016 TP5 media downloaded from msdn because the first step of SSMA installation failed with error that indicated the lack of .Net 2.0 and 3.5).
    I could not find the "Feedback" button in SSMA, so sorry for copy and paste the long error message.

    The error message is as follows:

    ==========================================
    See the end of this message for details on invoking
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    System.Data.SqlClient.SqlException: Incorrect syntax near 'TRIPLE_DES'.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
    at System.Data.SqlClient.SqlDataReader.get_MetaData()
    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
    at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
    at GenericScriptInstaller.SQL.CheckMasterKeyPassword(String password)
    at GenericScriptInstaller.GUI.UserControls.MasterKey.CheckPassword()
    at GenericScriptInstaller.GUI.UserControls.MasterKey.NextButtonPressed(Object sender, EventArgs e)
    at System.Windows.Forms.Control.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
    at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
    at System.Windows.Forms.Control.WndProc(Message& m)
    at System.Windows.Forms.ButtonBase.WndProc(Message& m)
    at System.Windows.Forms.Button.WndProc(Message& m)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
    at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

    ************** Loaded Assemblies **************
    mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.8742 (WinRel.050727-8700)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
    ----------------------------------------
    SSMA Script Installer
    Assembly Version: 6.0.0.0
    Win32 Version: 6.0.3254.4
    CodeBase: file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20Oracle%20Extension%20Pack/bin/SSMA%20Script%20Installer.exe
    ----------------------------------------
    GenericScriptInstaller
    Assembly Version: 1.0.5907.11600
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Microsoft%20SQL%20Server%20Migration%20Assistant%20for%20Oracle%20Extension%20Pack/bin/GenericScriptInstaller.DLL
    ----------------------------------------
    System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.8742 (WinRel.050727-8700)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    ----------------------------------------
    System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.8742 (WinRel.050727-8700)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.8742 (WinRel.050727-8700)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    ----------------------------------------
    System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.8742 (WinRel.050727-8700)
    CodeBase: file:///C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
    ----------------------------------------
    System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.8742 (WinRel.050727-8700)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
    ----------------------------------------
    System.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.8742 (WinRel.050727-8700)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
    ----------------------------------------
    System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.8742 (WinRel.050727-8700)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    ----------------------------------------
    System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.8742 (WinRel.050727-8700)
    CodeBase: file:///C:/Windows/assembly/GAC_64/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
    ----------------------------------------
    System.EnterpriseServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.8742 (WinRel.050727-8700)
    CodeBase: file:///C:/Windows/assembly/GAC_64/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
    ----------------------------------------

    ************** JIT Debugging **************
    To enable just-in-time (JIT) debugging, the .config file for this
    application or computer (machine.config) must have the
    jitDebugging value set in the system.windows.forms section.
    The application must also be compiled with debugging
    enabled.

    For example:

    When JIT debugging is enabled, any unhandled exception
    will be sent to the JIT debugger registered on the computer
    rather than be handled by this dialog box.
    ==========================================

    How can I deal with this error?

  3. champ says:

    when will be the final version released??

    1. It has now been released. See SSMA 7.0 Release

Skip to main content