How-to guides

Migrating databases

• Get set up

  Learn how to get set up to use Database Migration Service.

• Configure your source Oracle database

  Learn about how to configure your source Oracle database so that Database Migration Service can pull data from it and migrate the data into a destination.

• Work with Oracle database redo log files

  Learn how to work with Oracle database's set of online redo log files.

• Configure your destination Cloud SQL for PostgreSQL database

  Learn about how to configure your destination Cloud SQL for PostgreSQL database so that Database Migration Service can migrate data into it.

• Create a private connectivity configuration

  Create a private connectivity configuration so that Database Migration Service can use the information in the configuration to communicate with a source database over a private network.

• View a private connectivity configuration

  View high-level and detailed information about a private connectivity configuration.

• Create connection profiles

  Create connection profiles to a source Oracle database and a destination Cloud SQL for PostgreSQL database.

• Review connection profiles

  Review connection profiles.

• Manage connection profiles

  Perform actions on connection profiles.

• Configure your Ora2Pg

  Use the Ora2Pg migration tool to translate an Oracle database schema to a schema that's compatible with PostgreSQL.

• Create a conversion workspace

  Create a conversion workspace to convert the schema and objects from a source database into a format that's compatible with a destination database.

• Review conversion workspaces

  Review conversion workspaces.

• Manage conversion workspaces

  View detailed information about, modify, or delete conversion workspaces.

• Create a migration job

  Create a migration job.

• Review a migration job

  Review a migration job.

• Manage migration jobs

  Start, stop, resume, or delete migration jobs.

• Verify a migration

  Confirm that a migration job correctly migrated data from your source database instance to a destination Cloud SQL for PostgreSQL database instance.

• Finalize a migration

  Finalize a migration so that a destination Cloud SQL for PostgreSQL instance can be used as an application write instance.