Home

Cloud Database Report: The 'Highest Risk' Project in IT

3;
View this email in your browser

New tools help ease the pain of database migrations

6.1.21

Database migration is a growing issue as more businesses move terabytes and petabytes of data to the cloud.

In the latest real-world example, PayPay's tech team published a blog post detailing their experience migrating data warehouse workloads from on-premises to Google Cloud's BigQuery.

"As we worked through this project, it became clear that data movement is very contextual to our setup, and off-the-shelf tools had limitations in being able to seamlessly copy data to Google Cloud Platform," the authors wrote. "This was the hardest part of the whole project." 

PayPal did not say how many months it took to move 15 petabytes, only that it was "less than a year." That's in the ballpark of other major database migrations I've written about, which have ranged from six months to two years. 

Clearly, these are complex undertakings. Kelly Stirman, Google Cloud director of product management for databases, said not long ago that most IT organizations view database migrations as "about the highest risk thing you can do in all of IT." 

AWS, DataStax, Microsoft, Oracle, and other vendors have introduced new tools to help with the process, which includes planning, data replication/synchronization, data models, and app logic. 

Just last week, Google Cloud announced Datastream, a change data capture and replication service, with an Oracle to PostgreSQL Toolkit. Google Cloud also offered a Schema Assistant for MySQL or PostgreSQL migrations to its Cloud Spanner. 

For more see, “Cloud Vendors Confront ‘Highest Risk’ Projects: Database Migration”

And listen to our podcast, “Database Migration: One Year or One Click?”
 
While simple database migrations can be accomplished in a few days, enterprise-wide projects sometimes go on for months or years. So it's essential that IT teams define clear timelines for these migration projects and ensure that business leaders understand what to expect. 

John Foley, Editor
 
 

RECOMMENDED READING
 
Cloud Database Report
 
Cloud Database Top 20

Cloud Vendors Confront 'Highest Risk' Projects: Database Migration

Snowflake: 4 Big Steps on Journey to $1 Billion in Data Cloud Revenue

Who's #1 Cloud Database: Oracle, AWS, Microsoft? Cockroach, Databricks, Mongo? 

Surging Cloud Databases Will Blow Past Legacy Databases in Mega Platform Shift

The Cloud Database Market Is Booming: 10 Key Developments
 
Subscribe to Cloud Database Report. It's free!
Copyright © 2021 Cloud Database Report, All rights reserved.
You're receiving this email because you enlisted in the Cloud Database Report via the Cloud Wars website.

Want to change how you receive these emails?
You can update your preferences or unsubscribe from this list.
 
Twitter
Cloud Wars
open.php?u=80b000dcd583ac894c7c65387&id=289f9a4b84&e=6b8ac41067

Related Articles

10 Software Development Predictions for 2018

100 Great Supply Chain Partners 2017 Digital Edition

2016 Supply Chain Innovator Of The Year

Use below section to search for ERP Candidates or ERP service providing companies.

If you want to add yourself or your company, please log in and so do. Please send an email to admin of you need any help