Familiarize Yourself With DBMS Migration Best Practices to Ensure Success


Published: 18 October 2017 ID: G00332646

Analyst(s): |

Not a Gartner Client?

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

contact us online

Summary

DBMS migrations present many challenges and traps for the unwary. This research offers guidance about the techniques technical professionals can use to migrate between DBMSs and provides examples about how to detect and handle the many pitfalls.

Table of Contents

  • Problem Statement
  • The Gartner Approach
  • The Guidance Framework
    • Prework
      • Clear Objectives
      • Core Team
      • Management Support
    • Step 0: Become Familiar With Migration Technology and Techniques
      • Example of Typical DBMS Differences: SQL Server and Oracle
      • Example: SQL Server to Hana and Use of IDENTITY
    • Step 1: High-Level Assessment of the Feasibility and Effort to Migrate
      • Migration Metrics
      • Particular Risk Factors and Technical Conversion Challenges
      • Initial Architecture
      • Migration Approach and Estimates
      • High-Level Business Case and Feasibility Assessment
    • Step 2: Undertake a Detailed Migration Study
      • Turning Risk Into a Cost Estimate
      • The Correct Use of Contingency
      • A Useful Migration Sanity Check
      • Database Compatibility Options
      • Dynamic SQL Translation as an Alternative to Code Conversion
      • Built-In Translation Frameworks
      • Case Study: Thomas Publishing
    • Step 3: Carry Out the Migration
      • Case Study: Large Insurance Company
    • Step 4: Formal Cutover to Production
      • Case Study: REWE Systems
    • Follow-Up
      • Case Study: Converting Thousands of Schemas Through Repeatable Migration
  • Risks and Pitfalls
    • Related Guidance
  • 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.