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

Data Types
SQL Language Elements
Built-in SQL Functions

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

SQLines SQL Converter

SQLines Data

Migration to MariaDB

Migration to Oracle

Migration to SQL Server

Migration to MySQL

Migration to PostgreSQL

Migration to IBM DB2

Migration to Redshift

Migration to Databricks

Migration to Snowflake

Migration to Spark

Migration to Presto/Trino

Migration to Netezza

Migration to Greenplum

Migration to SingleStore

Application Conversion

Database Reference

Microsoft SQL Server (MS SQL) to Snowflake Migration

Migration Reference

SQL Language Elements

Data Types

Built-in SQL Functions