Microsoft SQL Server (MS SQL) to Snowflake Migration

SQLines provides tools to help you convert database schema (DDL), views, queries and SQL scripts from Microsoft SQL Server (MSSQL, MS SQL), Azure SQL Database, Azure Synapse to Snowflake.

  • SQLines SQL Converter - SQL scripts assessment and conversion tool

Databases:

  • Microsoft SQL Server 2019, 2017, 2016, 2014, 2012, 2008, 2005 and 2000
  • Snowflake

SQL Server to Snowflake Migration Reference

SQL Language Elements

Converting SQL language elements:

SQL Server Snowflake
1 string + string2 + … String concatenation CONCAT(string, string2, …)

Built-in SQL Functions

Datetime functions:

SQL Server Snowflake
1 GETDATE() Get the current date and time GETDATE() CURRENT_TIMESTAMP