Migrating Enterprise Databases and Data to the Cloud

Archived Published: 07 April 2017 ID: G00317167


Not a Gartner Client?

Want more research like this?
Learn the benefits of becoming a Gartner client.

contact us online


As technical professionals migrate on-premises systems to the public cloud, they need to know which databases to migrate, which tools and techniques to use, and how to run a successful migration project. This document provides guidance on migrating enterprise databases to IaaS and PaaS.

Table of Contents

  • Problem Statement
  • The Gartner Approach
  • The Guidance Framework
    • Prework
      • Business Strategy for Moving to the Cloud
      • Application Migration Strategy
      • Your Accomplishments in the Prework Stage
    • Step 1: Plan the Database and Data Migration
      • Identify the Success Criteria for Your Database and Data Migration
      • Define the Scope of Work for the Database and Data Migration
      • Choose the Tools and Techniques for Database and Data Migration
    • Step 2: Choose the Method of Bulk Loading On-Premises Data Into the Cloud
      • Transferring Bulk Data Using an Internet Connection
      • Transferring Bulk Data Using a Direct Network Connection
      • Transferring Bulk Data Using Physical Storage Devices
      • Loading Data From Cloud Storage Into Your Cloud Database
      • Your Accomplishments in Step 2
    • Step 3: Choose the Tools for Migrating the Database Structure and Code
      • Homogeneous Migration of Database Structure and Code
      • Heterogeneous Migration of Database Structure and Code
      • Agile/DevOps and Database Source Code Control
      • Your Accomplishments in Step 3
    • Step 4: Choose the Tools for Database Synchronization
      • Your Accomplishments in Step 4
    • Step 5: Create the Test Plans for the Cloud Databases and Applications
    • Step 6: Get the Right Help for Your Cloud Database Migration
      • Your Accomplishments After Step 6
    • Step 7: Perform the Migration
      • Provision the Resources in the Cloud
      • Perform the Bulk Data Extraction From the On-Premises Database
      • Bulk Load the Data From the On-Premises Database to the Cloud Database
      • Begin Synchronization of the Cloud Database With the On-Premises Database
      • Perform the Cutover From the On-Premises Database to the Cloud Database
    • Step 8: Operate and Optimize
    • Follow-Up
  • Risks and Pitfalls
    • Problems Might Arise in the Bulk Data Transfer
    • Data Synchronization Problems Might Make a Parallel Run Unfeasible
    • The Migration Project Could Easily Become Late and Overbudget
    • The Migration Plan and Objectives Might Be Misaligned
    • The Goals of the Cloud Migration Might Be Technically Unfeasible
    • Public Cloud Providers Might Not Meet Your Requirements
    • The Requisite Skills Are Not Available Internally or From Partners
    • Your Database Might Not Perform Adequately in the Cloud
  • Gartner Recommended Reading
© 2017 Gartner, Inc. and/or its Affiliates. All Rights Reserved. Reproduction and distribution of this publication in any form without prior written permission is forbidden. The information contained herein has been obtained from sources believed to be reliable. Gartner disclaims all warranties as to the accuracy, completeness or adequacy of such information. Although Gartners research may discuss legal issues related to the information technology business, Gartner does not provide legal advice or services and its research should not be construed or used as such. Gartner shall have no liability for errors, omissions or inadequacies in the information contained herein or for interpretations thereof. The opinions expressed herein are subject to change without notice.

Free Research

Discover what 12,000 CIOs and Senior IT leaders already know.

Free Access

Why Gartner

Gartner delivers the technology-related insight you need to make the right decisions, every day.

Find out more

Call +1 855-515-4486 or contact us

to become a Gartner client.