In this blog post, we examine how you can migrate data and schema from an existing PostgreSQL database using YugabyteDB Voyager. With a focus on data modeling for appropriate data distribution, we explore two different migration approaches: “Lift” and “Lift & Shift.”
See how easy it is to use the YugabyteDB Voyager data migration tool to migrate a web application from the Oracle database to a distributed YugabyteDB database cluster.
See how easy it is to use YugabyteDB Voyager to migrate a web application from a MySQL database to a distributed YugabyteDB database cluster.
See how how easy it is to use YugabyteDB Voyager to migrate a Node.js application backed by a single-node PostgreSQL database to a distributed YugabyteDB database cluster.
Accelerate database modernization initiatives and say goodbye to the limitations of your legacy or single-cloud databases. This blog post explains how YugabyteDB Voyager simplifies the entire database migration process, including cluster preparation, schema migration, and data migration.
In 2019, I gave a presentation with the title, “19 features you will miss if you leave Oracle.” The talk focused on features used every day with Oracle—and those that may not be available in other databases. However, the goal of this presentation was not to influence any decision or outcome.
Migrating from a commercial database is not about covering a full set of features. It’s a strategy to stay in control of the software that processes and stores enterprise data.
…
We understand that database migrations can be painful. We have helped users successfully migrate from MySQL to YugabyteDB, a PostgreSQL-compatible distributed SQL database. A very popular tool to accomplish this task is pgloader. In this post, we will cover how to migrate both your MySQL schema as well as data to YugabyteDB.
Before starting the migration there are a few prerequisites you’ll need to address.
…
A large, global financial services company is pursuing digital transformation initiatives across the board, with its biggest priorities focused around application modernization. Their goals were to untether from the mainframe, consolidate its numerous database technologies, and migrate to a modern microservices-oriented, cloud native architecture. Learn how they did it and the benefits they achieved.
Welcome to this week’s tips and tricks blog where we explore both beginner and advanced YugabyteDB topics for PostgreSQL and Oracle DBAs.
Please note that most examples in the post make use of the Northwind sample database. Instructions on how to get it installed are here.
Ok, let’s dive in…
In a nutshell,
…
Data migration can be a complex and time-consuming task, but proper planning can help streamline the process. In this blog, we’ll demonstrate how to migrate a Sakila demo database from MongoDB to a YugabyteDB cluster using Studio 3T, highlighting the key steps and considerations involved in the process.
