Gartner Research

Migrating Enterprise Databases and Data to the Cloud

Published: 07 April 2017

Summary

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.

Included in Full Research

  • 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
  • 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

Analysts:

Lyn Robison

Access Research

Already a Gartner client?

To view this research and much more, become a client.

Speak with a Gartner specialist to learn how you can access peer and practitioner research backed by proprietary data, insights, advice and tools to help you achieve stronger performance.

By clicking the "Continue" button, you are agreeing to the Gartner Terms of Use and Privacy Policy.

Gartner research: Trusted insight for executives and their teams

What is Gartner research?

Gartner research, which includes in-depth proprietary studies, peer and industry best practices, trend analysis and quantitative modeling, enables us to offer innovative approaches that can help you drive stronger, more sustainable business performance.

Gartner research is unique, thanks to:

Independence and objectivity

Our independence as a research firm enables our experts to provide unbiased advice you can trust.

Actionable insights

Not only is Gartner research unbiased, it also contains key take-aways and recommendations for impactful next steps.

Proprietary methodologies

Our research practices and procedures distill large volumes of data into clear, precise recommendations.

Gartner research is just one of our many offerings.

We provide actionable, objective insight to help organizations make smarter, faster decisions to stay ahead of disruption and accelerate growth.

Tap into our experts

We offer one-on-one guidance tailored to your mission-critical priorities.

Pick the right tools and providers

We work with you to select the best-fit providers and tools, so you avoid the costly repercussions of a poor decision.

Create a network

Connect directly with peers to discuss common issues and initiatives and accelerate, validate and solidify your strategy.

Experience Technical Professionals conferences

Join your peers for the unveiling of the latest insights at Gartner conferences.

©2022 Gartner, Inc. and/or its affiliates. All rights reserved. Gartner is a registered trademark of Gartner, Inc. and its affiliates. This publication may not be reproduced or distributed in any form without Gartner’s prior written permission. It consists of the opinions of Gartner’s research organization, which should not be construed as statements of fact. While the information contained in this publication has been obtained from sources believed to be reliable, Gartner disclaims all warranties as to the accuracy, completeness or adequacy of such information. Although Gartner research may address legal and financial issues, Gartner does not provide legal or investment advice and its research should not be construed or used as such. Your access and use of this publication are governed by Gartner’s Usage Policy. Gartner prides itself on its reputation for independence and objectivity. Its research is produced independently by its research organization without input or influence from any third party. For further information, see Guiding Principles on Independence and Objectivity.