Click me
Kickstart your modernization with Digital Transformation Starter Kit - Free Download
Announcing Mobilize.Net and Snowflake partner to migrate data warehouses to the cloud.
Announcing Mobilize.Net and Snowflake partner to migrate data warehouses to the cloud

Mobilize.Net Snowflake
SQL Migration Services

Teradata SQL, Stored Procedures, and BTEQ to Snowflake Automatically

Mobilize.Net and Snowflake partner to migrate data warehouses to the cloud

Announcing Mobilize.Net and Snowflake partner to migrate data warehouses to the cloud

Mobilize.Net and Snowflake have partnered together to make migration to the cloud fast, easy, and automated. Mobilize.Net is the only technology partner that can deliver the kind of completely automated code conversion that Snowflake was seeking. 

Mobilize.Net are the experts at code migration and Snowflake has built the premier architecture for data in the cloud. Stop paying high maintenance costs for spool space you rarely use. Take your legacy data warehouse to Snowflake with Mobilize.Net's automated migration tools and team of experienced software engineers. 


Save Time and Money with Mobilize.Net

Mobilize.Net is the legacy migration expert. We have been updating outdated code and applications for over 25 years. We have worked with over 80% of the Fortune 1000. You can read more about our customers here.

Through seamless, customized, and complete migration, Mobilize.Net has saved thousands of companies millions of developer hours and millions of dollars. We are the migration experts. With our focused conversion architecture using Abstract Syntax Trees (AST) to deliver the conversion tailored from a specific source to a specific target, no other company can efficiently automate your migration to the cloud.


Automatic Conversion of SQL and Scripts

Mobilize.Net can transform SQL, stored procedures, and outdated proprietary scripting languages to SQL and Python running on Snowflake's cloud platform. Starting with Teradata and Oracle, Mobilize.Net's automated migration service to Snowflake is available now with more source platforms being added constantly. Open standards, modern platforms, and native cloud will be your new paradigm, not ancient stored procedures written for last century's platforms.


More than just SQL Translation

While SQL translation can pose challenges to your average migration company, it's really the stored procedures and old scripts (such as BTEQ for Teradata), that get them stalled. Mobilize.Net automates the conversion of sProcs and BTEQ as efficiently as with SQL. Here's a quick conversion example of a procedure written with Dynamic SQL in Teradata:

-- Teradata Stored Procedure with Dynamic SQL

REPLACE PROCEDURE MY_DATABASE.DYNAMIC_RESULT_SETS()
DYNAMIC RESULT SETS 2
BEGIN
DECLARE SQL_CMD_0, SQL CMD_1 VARCHAR(20000) DEFAULT ' ';
DECLARE RESULT_SET_0 CURSOR WITH RETURN ONLY FOR FIRST_STATEMENT_0;
DECLARE RESULT_SET_1 CURSOR WITH RETURN ONLY FOR FIRST_STATEMENT_1;

--- MAIN ---
SET SQL_CMD_0 = 'SEL * FROM MY_DATABASE.EMPLOYEE';
SET SQL_CMD_1 = 'SEL * FROM MY_DATABASE.EMPLOYEE_PHONE_INFO';

--- CURSORS ---
PREPARE FIRST_STATEMENT_0 FROM SQL_CMD_0;
OPEN RESULT_SET_0;

PREPARE FIRST_STATEMENT_1 FROM SQL_CMD_1;
OPEN RESULT_SET_1;
END;
 

And the output in Snowflake is done in embedded JavaScript inside of Snowflake's SQL:

-- Snowflake Stored Procedure as JavaScript with Dynamic SQL

CREATE OR REPLACE PROCEDURE
MY_DATABASE.PUBLIC.DYNAMIC_RESULT_SETS()

 RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
var SQL_CMD_0 = ' ';
var SQL_CMD_1 = ' ';
var resultSetCounter = 0;
var tablelist = new Array;
var procname = 'PUBLIC.DYNAMIC_RESULT_SETS
var sql_command = 'select current session() || '_' || to_varchar(current_timestamp, 'yyymmddhh24missss')';
var stmt = snowflake.createStatement({
sqlText : sql_command
});
var res = stmt.execute();
res.next();
var sessionid = procname + res.getColumnValue(1);
//--- MAIN ---
SQL_CMD_0 = 'SELECT * FROM MY_DATABASE.PUBLIC.EMPLOYEE';
SQL_CMD_1 = 'SELECT * FROM MY_DATABASE.PUBLIC.EMPLOYEE_PHONE_INFO';
//--- CURSORS ---
var setname = SQL_CMD_0;
var tablename = sessionid + '_' + resultSetCounter++;
var sql_stmt = 'CREATE TEMPORARY TABLE ${tablename} AS ${setname}';
tablelist.push(tablename);
var RESULT_SET_1 = snowflake.createStatement({
sqlText : sql_stmt
}).execute();
return tablelist;

$$;

Say goodbye to static servers.
Say hello to the cloud.

Don't let the challenges of converting your proprietary scripts prevent you from transitioning to the cloud.

Migrate to the Cloud

SnowConvert ToTheCloud SQL Conversion
Time to Mobilize
Modernization Solutions

Mobilize.Net has been modernizing outdated code for over 25 years. Let us solve your hard problems.

Learn More About Automated Migrations

Time to Mobilize

“NTCNA Chassis Dynamics chose Mobilize.Net VBUC because the automated migration technology greatly sped up our move off VB6.”

- Aaron Bickel, Senior Manager, Nissan NA

“Mobilize.Net has a strong track record of building products that successfully automate challenging source code migrations, and this [product] will empower our customers to get up and running on Snowflake sooner.”

- Chris Degnan, CRO at Snowflake

“Mobilize tools create readable, maintainable, quality code,” said. “Mobilize uses familiar architecture and patterns which made it easy to immediately step into the code.”

- Matt Gropel, Director of Technology at AgWorks Software

“I am very pleased with the tool and your responsiveness. I have had at least 3 other aborted efforts to convert and hundreds of man-hours wasted. To get a clean compile after only 2 days is thrilling. I suspect that with about a week of effort, I can have a working .NET equivalent app.”

- Scott Lee, President, Superior Labels

We ran a proof of concept comparing the Visual Basic Upgrade Companion (VBUC) with other VB6 migration tools and we definitely preferred the way VBUC handled the conversion.

- James Lewis Stevenson II – Software Design Engineer, GT Software

Trusted by 80% of the Global 2000
logo-IRS
microsoft
nissan
CFM-materials
logo-AgWorks