Select Page

How-To: Migrate from SQL Server to Azure SQL

Watch this step-by-step video guide from Pat Callaghan, Technical Account Manager at WhereScape, to see how an on-prem SQL Server warehouse can be migrated to Azure SQL in days, not months.

By watching, you’ll learn how to:

  • Choose your target: SQL on Azure VM vs Azure SQL Managed Instance
  • Plan repo, scheduler placement and secure connectivity.
  • Configure Blob temp staging: keys, credential, external data source.
  • Update ODBC DSNs and RED connections, then regenerate scripts.
  • Work around Azure SQL constraints and use templates/enablement packs.
  • Test, run in parallel, then cut over to BI safely.

Migrations don’t need to be daunting: discover how it’s done.

Enter your details to access the recording.

By filling and submitting this form you understand and agree that the use of WhereScape’s website is subject to the General Website Terms of Use. Additional details regarding WhereScape’s collection and use of your personal information, including information about access, retention, rectification, deletion, security, cross-border transfers and other topics, is available in the Privacy Policy.

Data Platforms

Learn More About our Unique Data Productivity Capabilities for These Leading Platforms

Databricks

Move from development to production faster and easier than ever before with automated deployment of data pipelines to Databricks clusters.
fabric icon

Microsoft Fabric

Unify Microsoft’s Fabric lakehouse, Data Mesh and agile automation for fast, scalable workflows that consistently exceed expectations.
fabric icon

Snowflake

Start using Snowflake faster by simplifying and automating the design, build, and population of data warehouse tables.
fabric icon

SQL Server

Supercharge your data solutions – combine Microsoft SQL Server’s rock-solid performance with data automation, to deliver cost-effective analytics at speed.

“It took the architects a day and a half to solve all four use cases. They built two Data Vaults on the host application data, linked the two applications together and documented the whole process. This was impressive by any standard. After that it was an easy process to get all the documents signed.”

Daniel Seymore, Head of BI, Investec South Africa

Read Case Study

"At seven months into the project we can say it really worked out. We have been able to really quickly develop an initial MVP for our first country and that was really good. The automation and the changes we needed to do were rapidly applied. We had to remodel a few things and that was done within a day with the automation in WhereScape."

Carsten Griefnow, Senior BI Manager

Read Case Study

"It’s like having five people with only really two people working on it."

Will Mealing, Head of Data & Analytics at L&G

Read Case Study

EBOOK

Progressive Leasing Delivers Real-Time Analytics With Automated Data Warehousing

Download eBook →
GARTNER REPORT

From Source to Report: Simplifying Microsoft Fabric with WhereScape

Read Gartner Report →
ON-DEMAND WEBINAR

How-To: Migrate from SQL Server to Azure SQL

Watch Webinar →
VIDEO

How-To Video: Succeed with SQL Server Migrations at Scale

Watch Video →