Latest Release: SQL Server Migration Assessment (SSMA) v9.3 – SQL Server 2022 Support
What is the SQL Server Migration Assessment (SSMA) Tool?
The SQL Server Migration Assessment (SSMA) tool is a comprehensive tool designed to help you assess the feasibility of migrating from a range of popular databases to Microsoft SQL Server. It helps you to quickly identify which schema and data objects need to be migrated, and what potential issues may arise during the migration process.
What’s new in SSMA v9.3?
The latest version of SSMA (v9.3) adds support for Microsoft SQL Server 2022, which includes a number of new features including:
Columnstore Indexes
Columnstore indexes are a new type of index that is optimized for data warehousing workloads. They are designed to improve query performance by compressing and storing data in columns, rather than rows.
Always Encrypted
Always Encrypted is a new feature in SQL Server which allows sensitive data to be encrypted at rest and in transit. This ensures that the data is secure, even if a database is compromised.
In-Memory OLTP
In-Memory OLTP (formerly known as Hekaton) is a new feature that allows certain tables and procedures to be stored in memory, improving performance.
Other Improvements
The SSMA v9.3 also includes a number of other improvements, such as improved support for temporal tables, improved support for stored procedures, and improved support for the SQL Server Integration Services (SSIS).
Conclusion
The SQL Server Migration Assessment (SSMA) tool is a powerful tool that helps you assess the feasibility of migrating from a range of popular databases to Microsoft SQL Server. The latest version of SSMA (v9.3) adds support for Microsoft SQL Server 2022, which includes a number of new features including Columnstore Indexes, Always Encrypted, and In-Memory OLTP. Additionally, it includes a number of other improvements, such as improved support for temporal tables, stored procedures, and SQL Server Integration Services (SSIS).
References:
Release : SQL Server Migration Assessment (SSMA) v9.3 – SQL Server 2022 support
Top Keywords:
1. SQL Server 2022
2. SQL Server Migration Assessment
