Migrate SQL Server to Snowflake with SnowConvert
SnowConvert by Mobilize.Net

Microsoft SQL Server T-SQL to Snowflake

Mobilize.Net SnowConvert is the most effective tool for migrating Microsoft SQL Server DDL, DML, and T-SQL to the Snowflake Data Cloud. With over 500 million lines of code converted in the past year across multiple platforms, start accelerating your code migration today with the tool that has seen it all.

Get Started Today

Get to know Mobilize.Net SnowConvert for SQL Server

You've asked for it, and now it's here. From the makers of the heavily used SnowConvert for Teradata and SnowConvert for Oracle comes Mobilize.Net SnowConvert for SQL Server. SnowConvert automates the code conversion process to get you up and running on Snowflake faster. This is not "find-and-replace" conversion, but a complete semantic recreation of functionally equivalent code in Snowflake. Take a quick tour of SnowConvert by watching this video:


SnowConvert for SQL Server creates a functionally equivalent output in Snowflake SQL for any SQL and T-SQL code written for a SQL Server database. Specifically:

  • Tables and views (DDL and DML) are migrated to Snowflake SQL
  • Procedures, functions, and other T-SQL are migrated to your choice of:

To learn more about SnowConvert, you can visit our webpage on SnowConvert or fill out the form above to get started with the tool. 

Migration Plus Assessment

The first step in any successful migration is getting a plan in place, but the next step would be to get an assessment of the current platform. While SnowConvert for SQL Server automates the code migration, it's also a code understanding tool. SnowConvert builds an abstract syntax tree and a complete symbol table that create a semantic model of the source when you point it at any source codebase to perform the conversion. Out of those two artifacts, we can provide you a level of detail on the code that is present that you can only get with Mobilize.Net. Here's a quick look at the kind of assessment information that is provided:

  • Complete Assessment Report: This report gives you a summary of the objects (tables, views, procedures, functions, and other elements) found in your code, an estimate of the level of conversion you can expect for that code, and a summary of the estimated issues, warnings, and errors identified by the conversion process. This summary gives you a view into the level of work remaining to complete a migration after the automated code conversion. 

    Screenshot of conversion completion

  • Top Level Object Inventory: You'll get a complete list of every object (tables, views, procedures, functions, and other elements) found in your code. You'll also see how many lines of code are contained in each object, the location of each of those objects (schema and database), and the estimated conversion percentage for that object.

  • Errors, Warnings, and Issues Inventory: No migration can be 100% automated. There are always corner cases. Luckily for you, our assessment tool will report all of the pieces of code that could not be converted. The tool will give you a description on why it could not be converted, a severity/effort level for each error, and the exact location in the source code of the code segment that could not be converted.

    snowconvert_sql_server_issues_summary

This assessment is specifically designed to give you all the information you need to understand the migration ahead of you, as well as a sense of how much can be automatically converted using SnowConvert for SQL Server. You will get an inventory of any objects present in your code and a summary that helps you understand how much work remains to complete your migration.

Additional Resources 

Once you fill out the form above, you will receive an email from Mobilize.Net Studio with information on how to get started using Mobilize.Net SnowConvert for SQL Server. The email will also contain more instructions on how to use the tool, but you can always learn more about installation and setup as well as some valuable troubleshooting tips on our documentation page. 

Types of migrations

  • DDL/DML (*.sql) to Snowflake SQL (*.sql):
    SQL statements from SQL Server are converted to Snowflake SQL
  • T-SQL (*.sql) to JavaScript (*.sql):
    Stored procedures and functions are converted to JavaScript embedded in Snowflake SQL
  • Procedures (*.sql) to Snowflake Scripting (*.sql):
    Stored procedures can be converted to Snowflake Scripting if preferred over JavaScript embedded in Snowflake SQL

Other SnowConvert Source Platforms 

Learn more about the source data platforms that are supported with SnowConvert.

 

SnowConvert for TeradataGet Started with SnowConvert for Oracle

coming-soon-snowconvert-for-scala