Select a documentation version: <button class="button button-with-icon cloud-select-dropdown__button button-primary" aria-haspopup="true">15.13.0</button>

- [Current (18.4.0)](https://docs.cloud.google.com/alloydb/omni/containers/current/docs/migrate-data.md.txt)
- [18.4.0](https://docs.cloud.google.com/alloydb/omni/containers/18.4.0/docs/migrate-data.md.txt)
- [18.3.0](https://docs.cloud.google.com/alloydb/omni/containers/18.3.0/docs/migrate-data.md.txt)
- [18.1.0](https://docs.cloud.google.com/alloydb/omni/containers/18.1.0/docs/migrate-data.md.txt)
- [17.10.0](https://docs.cloud.google.com/alloydb/omni/containers/17.10.0/docs/migrate-data.md.txt)
- [17.9.0](https://docs.cloud.google.com/alloydb/omni/containers/17.9.0/docs/migrate-data.md.txt)
- [17.7.0](https://docs.cloud.google.com/alloydb/omni/containers/17.7.0/docs/migrate-data.md.txt)
- [17.5.0](https://docs.cloud.google.com/alloydb/omni/containers/17.5.0/docs/migrate-data.md.txt)
- [16.14.0](https://docs.cloud.google.com/alloydb/omni/containers/16.14.0/docs/migrate-data.md.txt)
- [16.13.0](https://docs.cloud.google.com/alloydb/omni/containers/16.13.0/docs/migrate-data.md.txt)
- [16.11.0](https://docs.cloud.google.com/alloydb/omni/containers/16.11.0/docs/migrate-data.md.txt)
- [16.9.0](https://docs.cloud.google.com/alloydb/omni/containers/16.9.0/docs/migrate-data.md.txt)
- [16.8.0](https://docs.cloud.google.com/alloydb/omni/containers/16.8.0/docs/migrate-data.md.txt)
- [16.3.0](https://docs.cloud.google.com/alloydb/omni/containers/16.3.0/docs/migrate-data.md.txt)
- [15.18.0](https://docs.cloud.google.com/alloydb/omni/containers/15.18.0/docs/migrate-data.md.txt)
- [15.17.0](https://docs.cloud.google.com/alloydb/omni/containers/15.17.0/docs/migrate-data.md.txt)
- [15.15.0](https://docs.cloud.google.com/alloydb/omni/containers/15.15.0/docs/migrate-data.md.txt)
- [15.13.0](https://docs.cloud.google.com/alloydb/omni/containers/15.13.0/docs/migrate-data.md.txt)
- [15.12.0](https://docs.cloud.google.com/alloydb/omni/containers/15.12.0/docs/migrate-data.md.txt)
- [15.7.1](https://docs.cloud.google.com/alloydb/omni/containers/15.7.1/docs/migrate-data.md.txt)
- [15.7.0](https://docs.cloud.google.com/alloydb/omni/containers/15.7.0/docs/migrate-data.md.txt)

<br />

This page outlines the process to migrate data from PostgreSQL or Oracle to AlloyDB Omni.

<br />

- [PostgreSQL to AlloyDB Omni](https://docs.cloud.google.com/alloydb/omni/containers/15.13.0/docs/migrate-data.md.txt#migrate-postgres)

- [Oracle to AlloyDB Omni](https://docs.cloud.google.com/alloydb/omni/containers/15.13.0/docs/migrate-data.md.txt#migrate-oracle)

## PostgreSQL to AlloyDB Omni

Use the following tools based on your migration complexity and downtime to migrate data from PostgreSQL to AlloyDB Omni:

| Migration type | Tool |
|---|---|
| Simple migration with sufficient downtime | [pg_dump](https://www.postgresql.org/docs/15/app-pgdump.html) to backup the existing database and [pg_restore](https://www.postgresql.org/docs/15/app-pgrestore.html) to restore the backup to the new database. |
| Complex migration with sufficient downtime | [pgloader](https://pgloader.readthedocs.io/en/latest/) to stream data from the source to the destination. |
| Complex migration with minimal downtime | [pglogical](https://docs.cloud.google.com/alloydb/omni/containers/15.13.0/docs/about-pglogical.md.txt) to replicate data from the source to the destination. |

## Oracle to AlloyDB Omni

If you have sufficient downtime to move the volume of data in Oracle and convert all Oracle resident application logic to PostgreSQL, use [Ora2Pg](https://ora2pg.darold.net/) for schema conversion, data movement, and code conversion.

If you have minimal downtime for the migration, use the following tools:

| To migrate | Use |
|---|---|
| Code and schema | [Google Cloud Database Migration Service](https://cloud.google.com/database-migration) to migrate the schema and code Ora2Pg for schema conversion, data movement, and code conversion Change Data Capture (CDC) tool as required to identify and captures data from, Oracle relational tables, and makes the change data available for use by applications. |