Migrate your Oracle database to an HM-managed database

This section collects all the steps you need to perform a migration from an Oracle database to an HM-managed database cluster.

Agent configuration

First, install and configure the Agent with your Oracle database. This provides a migration assessment that will help you scope the level of effort, complexity and time required for a migration. Additionally, the Agent extracts schema DDL that you can leverage to perform schema migrations with the built-in Migration Portal.

1. Prepare your Oracle database for registration with the Agent.

2. Create a machine user for the Agent for registration with the Agent.

3. Install the Agent.

4. Configure the Agent to register your Oracle database.

5. Run the Agent.

6. Run the Agent as a service.

7. Verify the Agent has registered your Oracle database and view the migration assessment results.

Migration

Then, leverage Hybrid Manager's Data Migration Service to perform a schema and data migration.

1. Create a destination database in HM.

2. Prepare the source Oracle database.

3. Handle constraints for schema migration.

4. Migrate schemas using the Migration Portal integration.

5. Create project credentials for the data migration.

6. Configure the Reader for a data migration.

7. Verify your source database appears in the HM Console.

8. Create and perform the data migration.

9. Finalize the migration (for streaming migrations only).

10. Apply excluded constraints.