Microsoft SQL Server to Synapse Migration

SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts and SQL scripts from Microsoft SQL Server (MSSQL, MS SQL), Azure SQL to Azure Synapse.

  • SQLines SQL Converter - SQL Conversion and assessment tool

Databases

  • Microsoft SQL Server 2022, 2019, 2017, 2016, 2014, 2012 and 2008
  • Microsoft Synapse

Migration Reference

Built-in SQL Functions

Converting functions:

SQL Server Synapse
1 IIF(condition, true, false) Check boolean condition CASE WHEN condition THEN true ELSE false END