Seamlessly lift and shift existing SSIS projects to Azure

Authored by Jess Rabida

Migrating your on premise databases to the any cloud platform often seems like a daunting process. However, leveraging Microsoft Azure’s cloud process can make it a simple, painless and valuable process. The Azure Data Factory (ADF) version 2, provides the ability to move existing SSIS on-premises environment to the Azure cloud without redesigning the application or making expensive code changes. Put simply, Azure’s “lift and shift” is the fastest route to migrating your existing SSIS packages to Azure because you can “lift” the SSIS packages up to an Azure environment and “shift” to use in ADF.

ADF allows raw data to be organized into meaningful data stores and data lakes for better business decisions. It’s built for complex hybrid extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects, and allows you to create data-driven workflows in the cloud for orchestrating and automating data movement and data transformation. ADF version 2 has a new feature which allows you to transform data using Azure Data Flow, which is equivalent to SQL Server Integration Services (SSIS). 

As a data movement and data transformation ETL/ELT tool, ADF version 2 is similar to on-premises SSIS. It can be used to combine all your structured (relational), unstructured (NoSQL db) and semi-structured data (logs, files, and media), with built-in connectors to Salesforce, ServiceNow, Dynamics, and more. Read the full article to learn how you can get started with a "lift" and "shift" process in just six steps. 

For more information on this topic or to learn how Baker Tilly specialists can help, contact our team.