What's new in Microsoft SQL Server Migration Assistant for Oracle (SSMA for Oracle) 9.4
Aug 5, 2023- Add support for BULK COLLECT conversion using bulk emulation function to retrive multiple rows in a single fetch.
- Fix for missing subscriptions in migration through migration at scale.
- Improve conversion of DECODE function.
- Improve conversion for comparison of empty strings with NULL.
New in Microsoft SQL Server Migration Assistant for Oracle (SSMA for Oracle) 9.3 (Mar 10, 2023)
- Added support for SQL Server 2022 target
New in Microsoft SQL Server Migration Assistant for Oracle (SSMA for Oracle) 9.2 (Nov 9, 2022)
- Added Support for legacy unicode string literals
- Added Support for arbitary expressions in ESCAPE clause
- Conversion Support for EXTRACT(XML) and XMLQUERY
- Enhanced data pipeline monitoring for at scale migration
- Conversion Support for EXTRACT(XML),EXTRACTVALUE and XMLQUERY
- Support for Azure Data Factory (ADF) pipeline monitoring
New in Microsoft SQL Server Migration Assistant for Oracle (SSMA for Oracle) 9.1 (Aug 23, 2022)
- Support for at scale data migration from Oracle to SQL with integration of Azure Data factory
- Add support for exclusion of system generated invisble column for conversion and data migration
- Improve get help experience
New in Microsoft SQL Server Migration Assistant for Oracle (SSMA for Oracle) 8.24 (Jun 6, 2022)
- Add support for LISTAGG function
- Add support for Oracle compound triggers
- Improve detection logic for JOIN clause and PIPELINED functions
- Improve naming for "Save As" statements
New in Microsoft SQL Server Migration Assistant for Oracle (SSMA for Oracle) 8.23 (Nov 23, 2021)
- Support for mapping of DATE type from Oracle to the SQL Server DATE type in the Type Mapping setting
- Support for table partition added for Azure SQL Database targets with all table partition mapped to primary filegroup
- New option "Allow Statements from Files", for adding statements from file system
- Enhanced XML output when running in console mode
- New "Feedback" link in reports to send feedback
- In reports, enhanced visualization experience
New in Microsoft SQL Server Migration Assistant for Oracle (SSMA for Oracle) 8.22 (Nov 21, 2021)
- Allow to specify additional connection string options for target database connection
- Introduce summary charts in assessment reports
- Improve messages navigation in assessment reports
New in Microsoft SQL Server Migration Assistant for Oracle (SSMA for Oracle) 8.21 (Nov 21, 2021)
- Fix OLE DB connection string mode to respect the provider name
- Add missing ssma_oracle.fn_getColEntryByRange emulation function
- Use COUNT_BIG in row count queries for the target database
- Add setting to emulate Oracle's empty string behavior in coalesce operations
New in Microsoft SQL Server Migration Assistant for Oracle (SSMA for Oracle) 8.20 (Nov 21, 2021)
- Add support for partitioned tables
- Add conversion of SKIP LOCKED clause
New in Microsoft SQL Server Migration Assistant for Oracle (SSMA for Oracle) 4.2.2277 (Aug 16, 2010)
- Support for Data Migration using both Server Side and Client Side Data Migration Engines
- New SSMA Console application for command line execution
- Support for “Custom SELECT” statement in data migration
- Support for migrating from Oracle 11g R2