What's New in SSMA for Oracle (OracleToSQL)
This topic lists SSMA for Oracle changes in each release.
The July 2014 release of SSMA for Oracle contains the following changes:
Support for Azure SQL DB
Extension pack functionality moved to schema to support Azure SQL DB
Support for Oracle Materialized views
Support for SQL Server 2014 Memory optimized tables
Performance improvements tested for databases with over 10k objects
UI improvements for dealing with large number of objects
Highlighting of “well known” LOB schemas
Conversion speed improvements
Show object counts in UI
Report size reduction by more than 25%
Improved error messages for unparsed constructs.
The July 2011 release of SSMA for Oracle contains the following changes:
Support for conversion of Oracle sequence to SQL Server “Denali” sequence generator.
Improved error reporting during data migration.
Improved conversion of statement using reserved words.
Improved implicit conversion of date value in a function.
The April 2011 release of SSMA for Oracle contains the following changes:
Consolidated “SSMA for Oracle” product, which supports SQL Server 2005, SQL Server 2008 and SQL Server “Denali”.
Support for connecting and migrating to SQL Server “Denali”.
Enhanced client side data migration engine, supporting parallel migration of data.
Improved data migration performance with Simple and Bulk logged recovery models.
Backward compatibility of projects created by earlier versions of SSMA (v4.0 and v4.2).
SSMA for Oracle v5.0 product can be installed side by side (SxS) with older versions of SSMA (v4.0 and v4.2).
Support for reporting User Defined Types (includes subtype, VARRAY, NESTED TABLE, object table and object view) and their usages in PL/SQL blocks with special error messages.
The July 2010 release of SSMA for Oracle contains the following changes:
Support for migrating to SQL Server 2008 R2
New SSMA Console application for command line execution
Support for Data Migration using both Server Side and Client Side Data Migration Engines
Support for “Custom SELECT” statement in data migration
Support for migrating from Oracle 11g R2
The June 2008 release of SSMA for Oracle contains the following changes:
Improvements in Assessment Report were completed. It includes additional information for synonyms, raw source for parsable objects, panels and SQL Server logo removal, and layout persistence.
Improvements in object conversion:
Packages DBMS_LOB, DBMS_SQL conversion added.
Joins conversion revised.
Modification of collections and records conversion, now conversion of records in simple cases released via separate variables for each field.
Improvements of records and collections implementation.
Windowing aggregation functions added.
ROLLUP/CUBE clause added.
Improvement for NEXTVAL/CURVAL.
Columns grouping in SET clause, Grouping sets and grouping ID were added.
MERGE statement added.
Support of new datetime types and conversion of records and collections as CLR data types added.
New features of Tester were added. Tables now can be tested as objects using Tester, a call order of several testable objects in test case can be altered, user can test procedures and functions with records and collections as parameters and return values, and a dependencies analyzer was added to check only used tables.
The August 2007 release of SSMA for Oracle contains the following changes:
A new TESTER component lets you create, manage, and run test cases to verify converted SQL code.
Conversion of Oracle subtypes, collections, and local modules have been added to SQL converter.
A new synchronization feature lets you synchronize specific objects with SQL Server database.
New conversion options added.