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)) | |||||