This is the Trace Id: b8dc0284a58dee905a67d562d21005e3

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.

Download

  • Version:

    1.0

    Date Published:

    27/09/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.
Back To Top