IBM Consulting
Windows and SQL Server
Migration to Azure

UK’s Biggest
Healthcare Trust

Program Overview - Define Target database platform for MSE with costing and other feature benefits , Build parallel dataingestion strategy for migrated databases to support MSE request., Unlock potential savings through zeroing out infra cost,
Operational and management costs. Migrate the reporting platform to new modernized Power BI service

Situation

Solution

Benefits of Migrating toAzure

Single Server, multiple
Instances, Age-old Database
Services, No Encryption▪ Several Healthcare databases arepotentially unused on the existing onpremise server▪ Automated discovery and assessment
using Microsoft Tooling capabilities.

▪ Creation of Strategic database platform
to enable faster time to market▪ Simplified database portfolio, optimized
database usage.

Large Number of Unused or
retired database▪ Integrates with multiple remote
databases servers through linked
services and many of them do notsupport encryption in transit . Some are
not SQL type relational Databases andnot directly supported by Azure SQL
managed services▪ Modernization of IT infrastructure andmoving existing databases to Azure SQLManaged PaaS platform▪ Several SSIS packages that executes
the Business process and data ingestion
workflow. Many of them are run
manually.

Total 30+ Databases sizing~2TB▪ Multiple consumer of the data hub,Different reporting users , Hospitals,
Clinicians and data warehouse systemaccessing the database.
▪ Does not have any encryption at rest orin transit.

Modernize Jobs to run on thenew Azure Data Factory Pipeline▪ Runs reporting system on SSRS or Qlik
view technology platform.
▪ Need for database co-existence till thecut over▪ Curated solution to archive unuseddatabases to cold storage in order tosave cost. Optimized databaseconfiguration and scaling on demand.
▪ Provisioning of Key Vault services tostore the sensitive credential as astandard▪ Power BI platform for one stop
reporting solution. Reusing existing
infrastructure for gateway cluster
instead of provisioning new Cloudgateways.
▪ Data Factory pipeline conversion forexisting SQL agent jobs in order to takebenefit from the underlying Azure
compute infrastructure.
▪ Parallel execution strategy for migrated
database on new platform to supportcoexistence▪ 27 databases retired▪ 16 databases moved to Blob Coldstorage and to be restored ondemand▪ 30+ databases moved to new PaaS
Database platform on cloud.
▪ Reduction of Technical Debt
▪ Encryption at rest is auto enabled.
▪ Reports running in older systems areremediated.

▪ Modernized database features likeencryption at rest, AD based security, logging and alerting.
▪ Automated Backup , recovery and99.90% guaranteed availability▪ Better role-based access control▪ More Robust and secure cloud platform

2British
Multinational
Telecommunications
CompanySituation

Solution

Benefits of Migrating to Azure• 182 Servers and 62 Applications• IBM proposed a full scale movesolution by adopting Garage Method• No delays incurred in exiting the DC
resulted in cost savings for the client• Driven by Business objectives,migration strategies and approachwere defined• DB Farm migration to parallel
Cluster reduced the DB footprint by
8 SQL instances• Rehost (As-Is) of Application
Servers to Azure• The DB Migration strategy resultedin house keeping of DBs by cleaning
up data (~2TB) and simplifying thetarget cluster(s)• 65 DBs from 6 Failover Clusters & 2Always On SQL Clusters••

No understanding of Applications
which were managed by externalvendors
Database Farm complexities:• DBs of 31 Apps hosted on the farm
• Only 1/3rd of the SQL instances
provisioned are in use• Availability Groups created with nodatabase to manage• Improperly configured nodes ofthe cluster•

Application Clusters andApps in scope of migration

COTS• FCI SQL Server migration by using
Azure Shared Disk
• Parallel SQL Always On AvailabilityGroups cluster to host DBs ofvarious Apps

• Builds & Service Management
through Multi cloud Manager (VBMP)
bringing in the Automation• Use of right set of migration tools tomigrate the Clusters and standalone
servers• Application migrations implemented
in less than 6 months going throughfull cycle of implementation• Redefined change management toexpedite and optimize the approval
process

IBM Confidential

3

Health Care Data
Company inNorth America

Standardize Platform, DB andMiddleware

Reduce Cost of Operations

Improve Operational Efficiency

IBM were chosen by the client to migrate five (5) applications/services from the Data Center to Azure Cloud platform. It includes
detailed design for application migration to the targeted cloud platform, migration planning, migration build/implementation per
the detailed design, migration test planning and test implementation. At the end of application migration detailed design, client
will approve the design and schedule and agree to proceed forward with the application build.

Situation•Choice of Cloud Platform – Azurevs AWS•

Data Intensive - 100 TB of data in
SQL Server and over 500 TB ofdocument data processed andstored in ISILON storage•

Continued costs of DC•

Lack of clear modernization
strategy•

Reduce the risk of migration alongwith acceleration of new featuredelivery

Solution

Benefits of Migration to Azure• POC to evaluate the key decision
criteria and recommend the target
cloud platform• Defined a new development
experience with extensive use ofPAAS services• Future proofed Architecture• Reduction of Technical Debt byupgrading to Windows Server 2016
and SQL Server 2016

• Strong Azure DevOps experience &methodology• Azure Cloud Migration Experience• Consistent Delivery Performance• Clear modernization approach• Cloud Migration Factory toolset

Reduce DC Footprint• A hub and spoke design model
facilitating a highly secureenvironment• Migrated applications to App
Services running on anisolated(single-tenant) ASE withintegration back to services runningin on-prem• Incremental Roll outs Plan for Dev,QA, UAT, Demo, Training andProduction environments

Improve Release Cycles
IBM Confidential• Design Reviews with Microsoft tovalidate IBMs approach5