Advancing AI-assisted modernization with Sybase Copilot, enhanced Oracle conversions, and improved Azure SQL MI reliability
We’re pleased to announce the release of SQL Server Migration Assistant (SSMA) v10.5, delivering meaningful improvements across multiple flavours of SSMA to further simplify and de‑risk database modernization to Azure SQL and SQL Server.
This release focuses on expanding AI-assisted code conversion, improving conversion quality and reliability, and addressing key customer feedback from real-world large-scale modernization projects.
Here is a high-level overview of the features shipped as part of SSMA:
Introducing AI‑assisted Code Conversion with Microsoft Copilot in SSMA for SAP ASE
(SSMA for SAP ASE)
SSMA v10.5 introduces AI-assisted code conversion powered by Microsoft Copilot for SAP ASE (Sybase)—bringing the same modern Copilot experience already available in SSMA for Oracle to Sybase migrations.
With this capability, customers can now use Copilot to accelerate conversion of complex Sybase T‑SQL objects like procedures, functions, triggers, and other database objects to SQL Server and Azure SQL–compatible code.
Key highlights
- AI-assisted modernization: Copilot helps generate higher-quality converted code, reducing manual remediation effort. The conversion efficiency improves by ~30% using Copilot.
- Designed for complex workloads: Particularly useful for large, business-critical Sybase ASE applications. During migration, these complex workloads often face a huge number of errors which can be dealt using Copilot.
- Consistent Copilot experience: The Sybase Copilot workflow mirrors the Oracle-to-SQL Copilot experience, ensuring a familiar and intuitive user flow.
Please find a link to the detailed blog covering supported scenarios, and best practices for using SSMA Sybase Copilot.
Improved Code Conversion Quality for Oracle with Support for Larger Source Scripts
(SSMA for Oracle)
In SSMA v10.5, the Oracle PL/SQL to T‑SQL Code Conversion Copilot has been enhanced to support larger source scripts, enabling customers to convert more complex and sizable PL/SQL packages with improved reliability. We have doubled the size of the input tokens to accommodate larger code. We have also significantly increased the limit of output tokens for accurate explanations.
These enhancements help reduce the need to manually split large scripts and improve end-to-end conversion efficiency for enterprise-scale Oracle workloads.
Improved Reliability of Oracle PL/SQL Conversions on Azure SQL Managed Instance
(SSMA for Oracle)
SSMA 10.5 improves the reliability of running Oracle PL/SQL–to–T‑SQL converted procedures on Azure SQL Managed Instance by updating the SSMA for Oracle extension components used to support Oracle compatibility behaviors (for example, autonomous transaction patterns).
These updates strengthen connection handling to align with newer security and encryption defaults in the target environment, helping reduce runtime connection interruptions during procedure execution.
The improvements are included as part of SSMA 10.5, so customers can benefit without requiring manual workarounds or additional configuration changes.
Additional Fixes and Improvements
SSMA v10.5 also includes several smaller but impactful fixes across flavors:
- SSMA for Access: Improved reliability of Windows login resolution during migrations.
- General stability and usability improvements across assessment and conversion workflows.
Download SSMA v10.5
Get the latest versions of SQL Server Migration Assistant v10.5:
Microsoft