Overview
SQL Server Migration Assistant (SSMA) is a suite of five tools designed to automate migrations from Oracle, Access, DB2, MySQL and SAP ASE (formerly SAP Sybase ASE) to Microsoft SQL. It automates the conversion of database schemas to a Microsoft SQL Server schemas, deployment of the schemas, data migration to the target SQL Server (see below for supported versions), and validation of migrated objects.
What's new?
The latest releases of SSMA enhances the current ad-hoc statement assessment capability. When you have Oracle script bundled in files that needs to be converted, you can add statements from files directly to import the files and perform assessment and conversion.
Key Behavior
- Currently, it supports .sql file extension only
- The imported file in SSMA will maintain the file name of the .sql file.
- Every time when you import a file with same name, it will append an auto incremental number. Example: abc#2, abc#3
In addition, this release includes the following enhancements:
- Improved XML output when running in console mode
- A New "Feedback" link in reports for sharing product feedback You can include screenshots, log files etc.
- Enhanced visualization experience
SSMA for Oracle
- Support for mapping of DATE type from Oracle to SQL Server's DATE type in Type Mapping setting
- Support for table partition added for Azure SQL Database targets with all table partition mapped to primary filegroup
SSMA for DB2
- Improvements to TOTALORDER function
- Conversion support for ANCHORED datatype
SSMA for Access
- Enhanced conversion for tables without primary key
SSMA for Sybase
- Improved messaging for conversion of TRANSACTION_RPC statements
Downloads
Supported sources and target versions
Source: For the list of supported sources, please review the information on the Download Center for each of the above SQL Server Migration Assistant downloads.
Target: SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, Azure SQL Database, an Azure SQL Database managed instance, and Azure SQL Data Warehouse (Azure Synapse Analytics)*.
*Azure SQL Data Warehouse (Azure Synapse SQL Pool) is supported as a target only when using SSMA for Oracle.
Resources
SQL Server Migration Assistant documentation
Posted at https://sl.advdat.com/3H5Thy8
