Migrate data

Export data and schema from other databases and import into YugabyteDB

Migrating to YugabyteDB, a high-performance distributed SQL database, involves a series of carefully planned steps to ensure a seamless transition from your existing database environment, such as PostgreSQL, to a scalable, fault-tolerant, and globally distributed system. Whether you're moving from a monolithic setup or another distributed system, understanding the migration strategies, tools, and best practices is crucial to achieving a successful migration.

YugabyteDB Voyager

Yugabyte ships YugabyteDB Voyager, a comprehensive data migration tool designed specifically to help users migrate from traditional databases like PostgreSQL, Oracle, MySQL, and others to YugabyteDB. It offers a variety of features that make the migration process smoother, more reliable, and less error-prone.

To learn more about how to methodically export using YB Voyager, see Migrate.

Export your data

If you need to export your data manually, you can use the ysql_dump tool or use the COPY TO command to export your tables into CSV files.

To learn more about how to use ysql_dump and the COPY command to export your data, see Export data.

Import your data

To import data into a YSQL database manually, you can use ysqlsh tool or use the COPY FROM command to import CSV files into YugabyteDB.

To learn more about how to import your data manually and best practices, see Import data.

Verify migration

After the data has been imported into the newly set up YugabyteDB cluster, you need to verify and validate that the data and the schema have been migrated correctly to ensure smooth functioning of your services.

To understand the various steps involved in validating your data, see Verify migration.

Guide to migration from PostgreSQL

Migrating from one system to another is no trivial task. It involves pre-planning, exporting and importing schema, analyzing and modifying schema, exporting and importing data, and more. Follow these precautions and steps to ensure a smooth migration.

To understand the various steps involved in migrating from PostgreSQL and best practices, see Migrate from PostgreSQL.