Amazon Redshift to Microsoft SQL Server Migration

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

Databases:

  • Amazon Redshift
  • Microsoft SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008 and 2005

Migration Reference

Built-in SQL Functions

Converting string functions:

Redshift SQL Server
1 TRIM(string) Remove leading and trailing blanks from string TRIM(string) Since SQL Server 2017
RTRIM(LTRIM(string))