On-Premise SQL Server Data Warehouse Migration to Azure

QuickStart Migration to Azure SQL Database Managed Instance

It's time to migrate your data warehouse to the Cloud

The recurring need to upgrade your data warehouse to the latest version of SQL Server or faster, newer hardware is always around the corner - why not make this next move the last time? Companies are migrating their data solutions to the Azure cloud to take advantage of the Azure Data Services and running on Platform as a Service offerings where they never manage infrastructure or software versioning again.

No more hardware upgrades, no more Operating System and SQL Server patching, and you’re always on the latest version of SQL Server. With the added time savings, you can focus on things that add real value to your business like integrating new data sources, adding new data visualization capabilities, or tackling that machine learning, IoT, or artificial intelligence project you’ve been putting off.

From a vantage point in the cloud, the landscape changes...

Migrating your on-premise SQL Server DW and ETL solutions to Azure is just the tip of the iceberg. The innovation and feature-rich opportunities in Azure can move your BI and reporting onto PaaS as well, and your platform becomes nearly future proof with an on-ramp to a full, modern data platform architecture.  From up in the cloud, many of the technical barriers that make IoT, Big Data, and Artificial Intelligence solutions challenging to implement are dramatically reduced, or even eliminated. We'll help you understand the dynamic landscape of Cloud Scale Analytics.

 SERVICE GOALS

  • Review the current state of your data warehouse and establish a future state Azure vision & strategy
  • Migrate your on-premise SQL Server data warehouse and ETL to Azure SQL Database Managed Instance (MI)
  • Bonus Workshop: Learn how to deploy separate environments in Azure for Dev and Test, as well as modernize your data solutions using the latest and greatest data and AI tools in Azure

 SUMMARY

  • Fixed cost for migration project, including travel expenses
  • Migrate your on-premise SQL Server data warehouse and ETL to Azure
  • Testing is performed to ensure connectivity, solution parity, and performance
  • Bonus Data & AI modernization workshop is included
blueicon.jpg

WANT TO LEARN MORE ABOUT MIGRATING TO AZURE?

Migrate Your DW

Migrate Your DW


In this migration and upgrade QuickStart, a BlueGranite expert will work with your organization to lift and shift your on-premise SQL Server data warehouse and ETL to Azure SQL Server Managed Instance. We’ll start by meeting with you to review your existing architecture and solutions.
Design the Architecture

Design the Architecture


We’ll work with you to create an Azure architecture to meet your data warehouse needs and will break down Azure pricing. With a plan in place, we’ll work with your Azure subscription administrator to provision the proper Azure services and configure them.
Deploy & Test

Deploy & Test


Once the Azure services are deployed we’ll restore your SQL Server database backups to Azure and deploy your ETL. We’ll then test connectivity and run several performance iterations to gauge the necessary performance settings for your desired budget. Once complete, we’ll work with you to test your report connectivity and deploy other environments that are required in your software development lifecycles.
Modernization Workshop

Modernization Workshop


We won’t leave you hanging after the migration. Included in your offer is a Data & AI Modernization Workshop to help you roadmap to a modernized solution. In this workshop we’ll review Azure tools and capabilities to modernize your ETL and reporting with tools like Data Factory, Databricks, Power BI, and Azure Analysis Services. We’ll also discuss Azure tools to enable artificial intelligence and machine learning like R, Python, and the Azure Cognitive Services.