IBM Consulting
Windows and SQL Server
Migration to Azure

Agenda❑ Why Migrate to Azure?

❑ IBM Value Propositions for Migration Journey❑ IBM Framework❑ Migration Tools and Accelerators❑ Incentives for Migration© Copyright IBM Corporation

IBM Consulting2

What’s driving migrations to Azure?
Infrastructureoriented drivers
Quicklyintegrateacquisitions

UrgentCapacity
needs

Software &Hardware
refreshSecurity
threats

Softwareend ofsupport

Compliance

Datacenter
contract
expiry© Copyright IBM Corporation

App oriented
modernization drivers

Application
innovation
IBM Consulting

Migration and innovation triggers

3Windows Server and SQL Server
RUN BEST ON AZURE
Unmatched security••••Cloud on your terms

Get unified security
management and advanced
threat protection with Microsoft
Defender for Cloud•Bring Azure security,
management and governance toany infrastructure with Azure Arc•

Seamlessly migrate your onpremises VMware and Nutanix
environments with Azure
VMware Solution and Nutanix
Cloud Clusters on Azure

Proactively secure your server
workloads with Microsoft
Sentinel, a cloud-native SIEM
Encrypt data while in use withindustry leading confidential
computing•

Enable secure and reliable
connectivity between edge fileservers and Windows Server onAzure with SMB over QUIC

© Copyright IBM Corporation

IBM Consulting

Extend your on-premises
systems to Azure with Windows
Admin Center in Azure, Azure
File Sync, Azure Active
Directory, and Extended
Network for Azure

Outstanding offers
and programs• Save up to 80% with offers suchas Azure Hybrid Benefit, 3 yearsof free Extended Security
Updates, and reserved
instances, only on Azure• Save up to 93% when you move
to Azure SQL Managed Instance• Get industry leading priceperformance with SQL Server onWindows Server on Azure• Get help at every step of yourmigration and modernization
journey with the Azure Migrationand Modernization Program4

Unparalleled innovation for your Windows Server workloads© Copyright IBM Corporation

Automate configurationand management ofWindows Server VMs withAzure Automanage

Patch without rebooting
your Windows Server VMs
with Hotpatch, only onAzure

Deep management of Windows
Server in a familiar UI right fromthe Azure portal with Windows
Admin Center in Azure

Gain flexibility andconsistency with native.NET support in App
Service and Azure
Kubernetes Service

Get leading database
performance from fullymanaged, secure Azure
SQL

Enable secure mode workby deploying virtualdesktops and apps easily
with Azure Virtual Desktop

IBM Consulting

5

Azure is the cloud that knows SQL Server best
The family of SQL cloud to edge databases

SQL Server on Azure
Virtual Machines

Azure SQLManaged Instance

Azure SQL
Database

Azure SQL
Edge

Best for lift and shift
and/or workloads
requiring OS-level accessBest for modernizing
existing apps

Best for supporting
modern cloud apps

Best for extending
apps to IoT edge

Azure SQL enabled by Azure Arc
Run Azure SQL on premises and in multicloud environments© Copyright IBM Corporation

IBM Consulting

6

Which Azure SQL offering is right for you?
App Innovation

Benefits of PaaS

Do you need

• Lower administrative burden• A database model?

• Up to 100TB of database storage?

• Resource pooling for multi-tenant
SaaS?

• To automatically pause/restart aworkload?

App Modernization

Yes
No• No End of Support hassles• Fully managed and always
up to date
• Dynamic resource scaling• Built-in high availability andautomatic backups

No• Multimodel capabilities

Do you need
• An instance model?

• Native vNet support & <16TB ?

• On-premises SQL Servercompatibility?

• Near real-time data replicationfrom on-premises to the cloud?

Migration

Azure SQL
Database*
YesAzure SQLManaged Instance

NoBenefits of IaaS

Do you need
• OS level access?

• >16TB Storage?

• Capabilities at the VM level?

• SQL Server versions 2008 - 2019?

Yes*SQL Serveron Azure VMs• Maintain OS-level control• Easy lift-and-shift eliminates
app refactoring• Faster path to the cloud• SSRS/SSAS?

* Use Azure Arc to enable the same services in your datacenter or on the cloud of your choice, when a hybrid or multicloud approach is required© Copyright IBM CorporationIBM Consulting

7

Your business intelligence tools in Azure
Move to Azure VMs or choose managed services for data integration and analysis
SSISSSRSSSAS© Copyright IBM Corporation

IBM Consulting

8

IBM Value Propositions for Migration Journey
IBM’s Cloud Migration Service offerings help our clients accelerate modernization initiatives, reduce technical debt, protect legacy
investments, while minimizing business risk and improving business agility by moving their workloads to the cloud faster, cheaper, and more
efficiently through a combination of:•Automation powered by assets such as IBM Cloud Consulting Accelerator•

Data analytics and insights through IBM’s deep expertise in AI and ML models/services•

Augmented by assets from Neudesic and IBM Research
Dedicated Azure Migration Factory experienced in cloud native migration tools•

Staffed with certified professionals
Sustainability by design -Target environment is right sized, and our architecture is optimized to reduce energy consumption. Under-utilized application components areeither optimized or decommissioned.

80%

effort savings in40%

cost savings

25%

faster20%

reduction inthe Discovery phasein migration designdelivery of migrationoutcomesbusiness risk

Automation and pre-defined
Discovery patterns enable
these savings over traditional
methods

Accelerate modernization
initiatives, reduce technicaldebt, while minimizing businessrisk and improving businessagility

Enabled by ‘Migration-as-aCode’ utility and 200+ pattern
libraries in execution

Enabled by well defined
pathways to application
modernization© Copyright IBM Corporation

Enabled by pre-defined design
patterns
IBM Consulting

30+%
optimizing savings andequivalent carbon credits

9IBM Value Propositions for Migration Journey

40% More Cost
Effective

60% Faster
Time to Value

ReducedDelivery Risk

Single Team,
Agile Delivery Model

With economies ofscale and provenprocesses

Leveraging heavy
automation andestablished templatesWith proven frameworks
backed by 10,000+
development hours

Disciplined delivery with ageographically aligned
team to reduce errors© Copyright IBM Corporation

IBM Consulting

10IBM Framework & Tooling for Windows Server Migration to Azure
Objective:
Understanding the inventory ofthe current windows server
workloads in Physical/
VMware/Hyper-V Platforms

Objective:
Analyse migration parameters.

Key Factors:• Windows OS Version• Latency & Performance• Desired Security, Firewall• Application dependencies

Tooling :Automation:• Azure Migrate• Delivery Curator• Movere

Discovery

Objective:
Optimize and right size the VMs toreduce carbon footprint

Tooling :• Azure Site Recovery• Calidris• Azure Migrate

Tooling :• Azure Sustainability Calculator• Azure Well Architected Framework• Turbonomic• Sustainability Advisor

Objective:
Assess target migrationcompatibility.
Tooling :• Azure Migrate• Movere• Kahuna• Delivery Curator

IBM Consulting

Sustainability

Migration

AnalyseAssessment© Copyright IBM Corporation

Objective:
Migrate the source PhysicalServers/VMs/Hyper VM WindowsServers to cloud.

Selection
Objective:
Based on the key factor andBusiness driver analysis, selectthe target landing zone, size ofVMs, availability set and OS DiskValidation
Objective:
Performing cut-overvalidation post migration
Tooling :• Azure Site Recovery• Calidris• Azure Migrate11

IBM Framework & Tooling for SQL Server Migration to Azure
Objective:
Understanding inventory of thecurrent database server
workloads
Tooling :Automation:• Azure Migrate• Azure Service Map (Agent)• Delivery Curator

Objective:
Analyse migration factors.
Key Factors:• DB Migration Compatibility• Tooling support for Migration• Cumulative Database sizes• Database Integrations• Desired Security• Resiliency Patterns

Discovery

Objective:
Optimize storage and databaseusage, reduce carbon footprint

Tooling :• Database Migration Assessment• Database Migration Service (DMS)• Azure Data Factory bulk copy data
• Azure Devops ( Bacpac )• SQL data sync
• Kinisi, Calidris

Tooling :• Azure Sustainability Calculator• Azure Well Architected Framework• Turbonomic• Sustainability Advisor

Migration

AnalyseAssessment
Objective:
Assess target database migrationcompatibility
Tooling :• Azure Migrate• Database Migration Assessment(DMA)• Database Migration Service (DMS)• Kahuna© Copyright IBM Corporation

Objective:
Migrate the source databases totarget SQL Landing zone

IBM Consulting

Selection
Objective:
Based on the key factor andBusiness driver analysis, selectthe target DB landing zone.

Sustainability

Validation
Objective:
Performing cut-overvalidation post migration

Tooling :• Database
Migration
Service (DMS)• SQL Server Management
Studio (SSMS)

12

IBM Tooling Strategy – IBM IPs

We leverage best of Azure tools and IBM IPs. We differentiate through our IBM research, consulting & acquisition tools.
Accelerators forSQL/ WindowsMigration

IBM Consulting Cloud Accelerator

A revolutionary cloud acceleration platform that drive accelerated planning and low-touch execution, with consistent & predictable outcomes.

BlueCAT
Help clients to map theirtransformation journey

Cloud Transformation
Insight (CTI)

RedHat Migration
Toolkit

Provides deeper insights inclient applications,

Can analyse 1000s of Javaapplications. Recommends
suitable runtime.

Turbonomic

Arina

Move2Kube

Economic Impact Place.
Creates wave plan. Estimate
Support Cost

Discovers workload andprovides right sizing.

Cloud Transformation
Advisor (CTA)
Assess J2EE application
migration to WAS, JBoss
and WebLogic

Dream Advisor

Delivery Curator

Kinisi

KahunaAccelerate Data/AI
workload optimization
decisions

Performs discovery analysis
on infrastructure for affinity,Utilization, etc.

Design© Copyright IBM Corporation

Calidris

Replatform OLTP & OLAP.
Support multiple data &Schema migration patterns

Discover, Assess & Design
IBM Consulting

Automates rehost pattern
for Windows, Linux, Hyper-V
and VMware to Cloud

Provides infrastructure andapplication management
tool to provision virtualdesktop.

Supports Re-Platforming ofJava, Cloud Foundry,
Swarm, Docker toKubernetes and Open Shift.

Execute13

IBM Consulting Cloud Accelerator (ICCA)
PlanRehostManage

ExecuteReplatform

Refactor

Rebuild with SaaS

Rearchitect

Design Principles• Reduced delivery risk with Data Analytics &Insight tool backed by 10,000 dev hours &125+ engagements• Incorporates Well architected framework

Day 2 Ops(Application)
Day 2 Ops(Platform)

ICCA
Delivery Curator••

Business case, ROI
creation
Platform & App
Design•Hyperscaler First•

Foundation Setup

Discover•

Universal Data Ingestion•

Discovery & Workshop
AssistantInsights•

Cloud Assessment•Auto generated disposition roadmap

Migration as codeDesign•

Application Migration
Blueprints•

Sprint Planning•

Hyper Automation•

Execute at Scale•

DevOps Approach•

Declarative

ORCHESTRATIONGOVERNANCE
Private On-Premise© Copyright IBM Corporation

Public SaaS Public
IBM Consulting

Dedicated Off-Premise

Traditional On-Premise• Delivered by Hyperscaler Migration Factory• Strategic partnership with hyperscalers,partners• Powered by IBM Research, IBM Security &Acquisitions (Nordcloud, Taos, Neudesic,Turbonomic)• Hyper Automation - Declarative &Continuous Automation in collaboration withIBM Research• Enables Sustainable & secure Migration,
Modernization experience for clientsKey Benefits

80%
40%

25%

Increase in efficiency during discovery
leveraging automation & proven patterns
More cost-effective leveraging
pre defined design patterns

Faster migrations with proven frameworks
and 200+ pattern libraries in execution
14