Microsoft SQL Server (MS SQL) to Snowflake Migration

SQLines tools can 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 2022, 2019, 2017, 2016, 2014, 2012, 2008, 2005 and 2000
  • Snowflake

Migration Reference

SQL Language Elements

Converting SQL language elements:

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

Data Types

Datetime data types:

SQL Server Snowflake
1 DATETIME2(p) Datetime with fraction, 0 <= p <= 7, default is 7 TIMESTAMP(p) 0 <= p <= 9, default is 9

Built-in SQL Functions

Datetime functions:

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