More about Cloud Migration
- Petabyte-Scale Storage Success Stories With Cloud Volumes ONTAP
- Azure StorSimple EOL: Using Cloud Volumes ONTAP for Hybrid Cloud Management
- Refactoring Applications to Kubernetes in Cloud Migrations
- The War Over the Cloud Has Ended (and the Winner Might Surprise You)
- Modern Data Estate: What IT Leaders Need To Know
- Strategies for AWS Migration: The New 7th R Explained
- Cloud Computing Deployment Models and Architectures
- Cloud Adoption Strategy: What’s the Best Approach for Your Organization?
- What is Cloud Migration? Strategy, Process and Tools
- Hybrid Cloud Strategy: A Winning Model for Enterprises
- Google Cloud Architecture and Building Your Own Solution Architecture
- SnapMirror in the Cloud: New Use Cases for NetApp’s Data Replication Technology
- 8 Digital Transformation Technologies and Their Business Impact
- What Is Digital Transformation in Banking?
- Digital Transformation in Healthcare: 4 Key Trends
- Digital Transformation: Examples from 5 Industries
- The Future of Cloud Computing: 5 Trends You Must Know About
- 5 Types of Digital Transformation and the Technologies that Power Them
- Digital Transformation Strategy: 6 Tips for Success
- Kubernetes Data Mobility with Cloud Volumes ONTAP
- Application Migration to Azure: 4 Approaches and One Migration Tool
- Cloud First Strategy: Challenges, Considerations, and Best Practices
- Application Migration to AWS: Free Tools to Ease Your Migration
- Why Cloud Adoption Fails and 6 Tips for Success
- Cloud Application Migration: A Practical Guide
- AWS Snowball vs Snowmobile: Data -Migration Options Compared
- AWS Snowball Edge: Data Shipping and Compute at the Edge
- AWS Snowmobile: Migrate Data to the Cloud With the World’s Biggest Hard Disk
- AWS Snowball Family: Options, Process, and Best Practices
- AWS Cloud Adoption Framework (CAF): 6 Migration Perspectives
- Top 3 Cloud Adoption Frameworks: Your Path To The Cloud
- AWS Snowball Pricing Simplified
- Azure Cloud Adoption Framework: The 9 Methodologies Explained
- Cloud Roadmap: Mapping Out Your Path To The Cloud
- Hybrid Deployment on Google Cloud: Meet Google Anthos
- 3 Ways to Create an Azure Migrate Project
- Azure Migration Step by Step: Discover, Migrate, Optimize, and Monitor
- Migrate from VMware to Azure: The Basics and a Quick Tutorial
- Migrate SQL Server to Azure: Options, Tools, and a Quick Tutorial
- Migrate Databases to Azure: 3 Quick Tutorials
- 4 Ways to Migrate SQL to Azure
- Azure Migration Program: 4 Key Elements
- Azure Migrate: Key Components and a 4-Step Migration Plan
- Cloud Journey: 6 Stages of Cloud Adoption
- 5 Azure Data Migration Tools You Should Be Using
- Azure Migration Tools: One-Click Migration for VMs and Data
- Typical Mistakes and Misconceptions Business Leaders Have About Hybrid and Multicloud
- Google Cloud PostgreSQL: Managed or Self-Managed?
- AWS Storage Gateway: Connecting Your On-Premise Storage to the Amazon Cloud
- Azure PostgreSQL: Managed or Self-Managed?
- Cloud Scalability: How Cloud Volumes ONTAP Stores Petabytes of Data
- AWS Migration: Understanding the Process and Solving 5 Key Challenges
- Google Cloud Pricing vs AWS: A Fair Comparison?
- VMware Cloud Services: A New Option for Hybrid Cloud Management
- AWS PostgreSQL: Managed or Self-Managed?
- Google Cloud MySQL: MySQL as a Service vs. Self Managed in the Cloud
- Azure MySQL: MySQL as a Service vs. Self-Managed in the Cloud
- AWS MySQL: MySQL as a Service vs. Self Managed in the Cloud
- Cloud Adoption for Financial Companies
- VMware on AWS: Architecture and Service Options
- VMware on Google Cloud: A Deployment Roadmap
- VMware on Azure: One-Step Migration to the Cloud
- Better in the Cloud: Workloads Gartner Says You Should Move to the Cloud Now
- 3 Cloud Migration Approaches and Their Pros and Cons
- Oracle on Google Cloud: Two Deployment Options
- How to Upload Files to Azure Blob Storage with AzCopy, PowerShell, and More
- Oracle on Azure: Fully Managed vs Self Managed
- Azure SQL Server: Managed Service vs Self Managed
- Google Partners with NetApp on New Bare Metal Solution in the Cloud
- AWS Database Migration Service: Copy-Paste Your Database to Amazon
- SQL Server on Google Cloud: Two Deployment Options
- GCP Migration with Cloud Volumes ONTAP
- SQL Server in AWS: Two Deployment Options
- Azure Database Migration Service: Automate Your Cloud DB Migration
- Azure Managed Service Provider: How to Save Time and Reduce Cloud Overhead
- Hybrid Cloud Storage: The Best of Both Worlds
- Hybrid Cloud Storage Solutions for AWS Compared: Storage Gateway vs Cloud Volumes ONTAP
- AWS Oracle: Two Options for Migrating Your Oracle DB to Amazon
- Migrating Physical Server to AWS: Now Free with AWS CloudEndure
- Azure Hybrid Cloud:
Azure in Your Local Data Center - What Is a Lift and Shift Cloud Migration?
- Google Cloud Migration Tools: Copying 1GB or 500TB? Learn How
- VMC on AWS Vs. Cloud Volumes ONTAP
- AWS Cloud Migration Services: Don’t Migrate Alone
- 5 Steps to the Cloud: AWS Migration Checklist
- Setting up Storage Gateway with Amazon EC2
- VMware Cloud on AWS: How Fujitsu Saves Millions Using Cloud Volumes ONTAP
- SQL Server End of Life Challenges and How Cloud Volumes ONTAP Can Help
- The Cloud Tiering Service Architecture: How We Get Cold Data from Your Data Center to the Cloud
- Cloud Data Integration 101: Benefits, Challenges, and Tools
- Google Cloud Migration: Why and How to Make the Move
- What’s the Easiest Way to Start Using the Cloud? Three Cloud Onboarding Approaches
- AWS vs Azure vs Google Cloud: Choosing the Best Cloud Provider for You
- Cloud Migration Tools: Transferring Your Data with Ease
- Azure Migration Strategy: Four Steps to the Cloud
- 11-Step Azure Migration Checklist
- AWS Migration Strategy: The 6 Rs in Depth
- Officeworks Adopts a Cloud-First Strategy with Cloud Volumes ONTAP
- Azure Migration: The Keys to a Successful Enterprise Migration to Azure
- Cloud Volumes ONTAP: Cloud Migration Case Studies
August 10, 2021
Topics: Cloud Volumes ONTAP AzureData MigrationDatabaseElementary7 minute read
What Is SQL Server Migration to Azure?
Microsoft SQL Server is a relational database management system (RDBMS) commonly used for tasks like transaction processing, business intelligence (BI), and analytics.
Azure offers three main options to implement SQL Server in Azure, including:
- IaaS on Azure—install and run the database on Azure virtual machines (VMs).
- PaaS on Azure—migrate your on-prem database to Azure SQL Database.
- IaaS and PaaS—use Azure SQL Database managed instances to gain both IaaS and PaaS features.
Azure offers free, automated tools that can help you perform Azure migration for on-premises SQL Server databases, using any of the above deployment models.
In this article, you will learn:
- SQL Server Migration to Azure: Options and Tools
- Tutorial: SQL Server Migration to Azure SQL Database
- Migrate SQL Server to Azure with NetApp Cloud Volumes ONTAP
SQL Server Migration to Azure: Options and Tools
SQL Server Migration Options
Azure SQL Database
This is a fully managed platform as a service (PaaS) designed to handle SQL Server workloads. It offers many database management features, including built-in high availability, performance, scalability, and intelligent query processing capabilities.
Azure SQL Database supports a wide range of use cases, offering multiple service tiers and deployment models. It also offers features that can help you modernize applications—for example, eliminating dependency on components like SQL Agent jobs that run at the instance level.
An advantage of this service is that it lets you bring your own SQL Server license (BYOL), using the Hybrid Benefit program.
Azure SQL Managed Instance
Azure SQL Managed Instance lets you migrate applications from an on-premises data center to Azure with minimal changes to database or application code. The service runs SQL Server in a dedicated VM on Azure, giving you more control over configuration, but manages the VM and operating system for you. It completely isolates your instances using native support for Azure Virtual Networks (VNets).
Azure Virtual Machines
You can run SQL Server directly in a self-managed Azure VM. This deployment option gives you the same level of control and customization of database host and configuration as you would have in your local data center.
Azure VMs are available in a wide range of sizes and different geographic regions across the globe. Azure offers a VM image gallery that lets you create SQL Server VMs with the operating system and version edition that suits your needs.
Here are several key advantages of migrating on-premises workloads to SQL Server on Azure VMs:
- Using an SQL Server environment while still maintaining control over the operating system.
- Gaining access to cloud-based features like built-in VM high availability and automated backups.
- Deploying full versions of cloud-based SQL Server without the need to manage on-premises hardware.
- Taking advantage of simplified licensing costs, which are included in the price of the Azure VM.
Learn more in our guide Azure SQL Server: Managed Service vs Self Managed
SQL Server Migration Tools
Here are several tools that can help you migrate SQL Server to Azure.
Azure Migrate
This service is designed to help you identify and assess SQL data on VMware. Azure Migrate offers recommendations for Azure SQL deployments, as well as monthly cost estimates and recommendations for target sizing.
Data Migration Assistant
This desktop tool can help you achieve single-database SQL Server migrations to Azure SQL Database. You can use it to migrate both data and schema.
You can install Data Migration Assistant on an on-prem server or on a local machine with connectivity to the source databases. The tool logically moves data between objects located in your target and source databases.
Azure Database Migration Service (DMS)
This service automatically migrates on-premises SQL Server instances to the managed Azure SQL Database service. You can use it to automatically migrate using PowerShell, or manually migrate via the Azure portal.
When using Database Migration Service, you must choose a preferred Azure virtual network for provisioning. This is critical to ensure connectivity to source SQL Server databases.
Tutorial: SQL Server Migration to the Azure SQL Database
This tutorial shows how to move your SQL Server database to the Azure SQL Server, Azure’s fully managed database-as-a-service offering.
Pre-Migration
Check that the database supports your source environment and begin the pre-migration stage, in which you assess migration feasibility, discover resources, identify and remediate potential obstacles to migration.
Discovery
Scan your network for all SQL Server instances and other relevant features. You can use Azure Migrate to assess the migration suitability of each on-premises server and estimate their running costs in Azure.
Assessment
Assess the compatibility of your on-premises SQL Server databases with Azure SQL Database. Data Migration Assistant (from version 4.1) can provide recommendations for Azure target and the SKU (VM size) that can support your workloads.
To conduct the assessment:
- Open the Data Migration Assistant (DMA)
- Select File
- Select New assessment
- Specify your project name, under Source, choose SQL Server, and under Target, choose Azure SQL Database.
Image Source: Azure
- Select the assessment report categories you want to use—use feature parity for comprehensive recommendations and compatibility issues to identify issues with unsupported or partially supported features, and get recommendations for dealing with them.
- Specify your source database connection details to connect to it.
- Select Start assessment to identify issues hindering migration or affecting feature parity.
- Review the reports generated by the assessment—you can export it to a shareable file and determine which compatibility issues you intend to remediate.
- Identify which Azure SQL Database SKU best suits your on-premises workloads.
Migration
Once you complete the pre-migration stage, you can start migrating your data using your preferred migration strategy with Data Migration Assistant.
Use the following steps:
- Download DMA and install it.
- Open a new project and under Type, select Migration.
- Select source and target as SQL Server and Azure SQL Database, respectively. Select Schema and data as the scope of migration and choose Create.
- Specify the details of the source server (e.g., server name, credentials) in your migration project.
- Specify the details of the target server (e.g., the source server name, target database and credentials).
- Select and deploy schema objects to the target database.
- Select Start data migration and proceed to monitor migration progress.
Post-Migration
Following a successful migration stage, you can perform post-migration tasks to help ensure things are functioning properly.
Remediation of applications
Once you’ve migrated data to your target environment, make sure the applications previously connected to your source database can now connect to and use the target. In some cases, this may require changes to your applications.
Testing
Perform tests to validate your source and target database and to assess performance. You can do this by constructing a set of validation queries. Set up a testing environment (an isolated duplicate of the databases to be tested), run validation and performance tests, and analyze the results.
Migrate SQL Server to Azure with Cloud Volumes ONTAP
NetApp Cloud Volumes ONTAP, the leading enterprise-grade storage management solution, delivers secure, proven storage management services on AWS, Azure and Google Cloud. Cloud Volumes ONTAP capacity can scale into the petabytes, and it supports various use cases such as file services, databases, DevOps or any other enterprise workload, with a strong set of features including high availability, data protection, storage efficiencies, Kubernetes integration, and more.
In particular, Cloud Volumes ONTAP helps in addressing database workloads challenges in the cloud, and filling the gap between your cloud-based database capabilities and the public cloud resources it runs on.
Cloud Volumes ONTAP also assists with lift and shift cloud migration. NetApp’s data replication tools SnapMirror® and Cloud Sync service will get your data to the cloud.
Learn more in these Cloud Volumes ONTAP Databases Case Studies and these Cloud Migration Case Studies.
