What's New in SSMA for Oracle (OracleToSQL)
Published: April 1, 2016
This topic lists SSMA for Oracle changes in each release.
The May 2016 release of SSMA for Oracle contains the following changes:
- Added support for SQL Server 2016
- Added conversion of Oracle flashback archive tables to SQL Server temporal tables
- Added conversion of Oracle VPD Policy converting to SQL Server Policy objects (Row Level Security for Oracle)
- Decreased time of initial loading for Oracle
- Improved parser and resolver
- Removed installer check for .Net 2.0
- Updated Extension Pack dependency from .Net 3.5 to .Net 4.0
- Fixed "save project" and "open project" commands for SSMA Console
- Fixed "securepassword" command for SSMA Console
- Fixed counting of objects for initial loading
- Fixed converting of character data types for Oracle
- Fixed bug in global settings
The March 2016 preview release of SSMA for Oracle contains the following changes:
Support migration to SQL Server 2016
Support for migrating Oracle Row Level Security (with some limitations)
Support for migrating Oracle in memory tables to SQL Server Column Store
The January 2014 Maintenance release of SSMA for Oracle contains the following changes:
Added support for Clustered Indexes
Fixed slow Oracle schema queries (RFC 5076207)
Fixed connect to Azure from console
Added View Log Menu Item to SSMA (RFC 5706203)
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 April 2014 release of SSMA for Oracle contains the following changes:
Added support of MS SQL Server 2014.
Added support of Oracle 12 and query optimization.
Fixed bugs regarding conversion to Azure.
Fixed bugs regarding invisible report pages in IE 10.
The January 2012 release of SSMA for Oracle contains the following changes:
- Support RowType and RecordType input parameters defaulted to NULL.
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.
The April 2007 release of SSMA for Oracle was the initial release.