Convert Queries with SSMA at Scale

A set of SQL and Powershell scripts to to help with the bulk conversion of competitive database queries to SQL Server TSQL using SSMA.

Important! Selecting a language below will dynamically change the complete page content to that language.

Select language

Version:
1.0
Date Published:
9/27/2024
File Name:
ConvertQueriesWithSSMAatScale.zip
File Size:
55.9 KB
In some cases, customers have captures of application generated queries that were run against the source database engine and want to convert them into TSQL to help the migration effort and/or understand the types of errors development teams will encounter. To help with this requirement, our team put together a set of PowerShell scripts to enable customers to use SSMA to convert queries and harvest the warnings and errors produced at scale.
Supported Operating Systems
Windows 11, Windows Server 2022, Windows Server 2019
The file is a zipped folder that contains the scripts. Follow the instructions in the User Guide to set up the environment and run the scripts.
Choose the Download button on this page to start the download. Unzip the folder on a Windows machine and customize the PowerShell (.ps1) scripts as required for your local environment.