The following procedure explains how to migrate data from a MySQL source database to a MySQL target database, which contain the settings for running migration jobs with Database Migration. You can create multiple migration resources with different parameter settings to test different scenarios.

Creating a migration

1. Log in to the Console as a user with permissions to access Database Migration.

2. Open the navigation menu. Under Database Migrations click Migrations. A list of the migration resources in the currently selected compartment is displayed.

3. Click Create migration.

   This opens the Create migration wizard.

4. In the General information step, configure the following settings, then click Next.

   • Name: Enter a unique name for the migration.

     On completion of the Create Migration wizard, the name you enter here is displayed in the list of migrations on the Migrations page.

   • Add an optional Description: for the migration resource.

   • Compartment: Select the compartment in which the Database Migration service is hosted.

5. The Show advanced options section allows you to optionally create tags.

6. In the Select databases step, enter the following information, then click Next.

   Select the Source database.

   Select the Target database.

   Note
   
   Currently, OCI HeatWave service is supported as the target database. For a list of supported databases, see Creating MySQL connections.

7. In the Migration options step, select the Object storage bucket in compartment: transfer medium for initial load option.

   If the bucket is in a different compartment, click Change Compartment to look in another compartment.

8. If you want to create an online migration, check the Use online replication option to enable the replication of all data and metadata transactions from the source to the target database, committed after the initial load has begun. For additional optional configurations, see the Replication tab in the Show advanced options. Optionally, you can set some additional properties which can affect the performance of your online migration.
   Note
   
   Currently, for MySQL to MySQL migrations, Oracle Cloud Infrastructure Database Migration supports GoldenGate Service Integration for replication.
   Note
   
   Skip this step for offline migrations.

9. Optionally, select Show Advanced Options to configure advanced replication, validation, and Oracle GoldenGate settings.

   For details about these settings see Selecting objects for MySQL migration, Configuring initial load advanced options for MySQL migrations, Configuring validation options, and Configuring optional replication advanced options.

10. Click Create.

    The migration is loaded, and a new Migration Details page opens showing the information, metrics, and operations for the migration.

    The status of the creation operation is shown under the DM icon. When the status is Active, you can run migration jobs with the migration.

    Alternatively click the Save as stack option to save the migrations as a stack.

    The Save as stack pane is displayed. You can save the migration resource configurations as a stack. Use the stack to install, configure, and manage the resource through the Resource Manager service.

    The following options are available:

    1. Name (Optional)
    2. Description (Optional)
    3. Save in your compartment
    4. Optionally, add Tags to organize your resources.
    5. Click Save to save as a stack.
    6. Click Cancel if you do not want to save the stack.

    After you save the Stack, it displays a link in the upper right corner that directs you to the newly created Stack in the Resource Manager. See the following topics for the next steps: