Create a migration job

Overview

Important: Before creating a migration job, make sure that you have created:

• Connection profiles for both your source Oracle database and your destination Cloud SQL for PostgreSQL database instance.
• A conversion workspace that Database Migration Service uses to convert the schema and objects from your source database to a format that's compatible with your destination database instance.

For more information, see Create connection profiles and Create a conversion workspace.

Database Migration Service uses migration jobs to migrate data from your source database instance to the destination Cloud SQL database instance.

Creating a migration job includes:

• Defining settings for the migration job
• Specifying information about the connection profile that you created for your source database (source connection profile)
• Specifying information about the connection profile that you created for your destination database (destination connection profile)
• Configuring the objects that you want to migrate from the source database
• Testing the migration job to ensure that the connection information you provided for the job is valid

Database Migration Service comes equipped with a wizard to help you create a migration job. This wizard consists of four panels: Get started, Define a source to a destination, Configure migration objects, and Test and create migration job. Information on how to populate each panel is provided in the various sections of this page.

You can pause the creation of a migration job by clicking SAVE & EXIT. All of the data that was populated until that point is saved in a draft migration job, and you can access this job in a DRAFTS tab.

To finish creating a migration job, navigate to the tab, and then click the job. The creation flow resumes from where it was left off. The job remains a draft until you click CREATE or CREATE & START.

Define settings for the migration job

1. Go to the Migration jobs page in the Google Cloud Console.
2. Click CREATE MIGRATION JOB at the top of the page.
3. Provide a name for the migration job. Choose a friendly name that helps you identify the migration job. Don't include sensitive or personally identifiable information in the job name.
4. Keep the auto-generated Migration job ID.

5. Select Oracle from the Source database engine drop-down list.

6. From the Destination database engine menu, select Cloud SQL for PostgreSQL.

7. Select the destination region for your migration. This is where the Database Migration Service instance is created, and should be selected based on the location of the services that need your data, such as Compute Engine instances and App Engine apps, and other services. After you choose the destination region, this selection can't be changed.

8. Optional: Expand the Advanced encryption options section and specify whether you want to manage the encryption of the data that's migrated from the source to the destination. By default, your data is encrypted with a key that's managed by Google Cloud.

   If you want to manage your encryption, you can use a customer-managed encryption key (CMEK). The key must be in the same location as your Cloud SQL for PostgreSQL database. For example, for databases located in us-west1 can use only keys in us-west1.

   1. Select the Customer-managed encryption key (CMEK) radio button.
   2. From the Select a customer-managed key menu, select your CMEK.

      If you don't see your key, then click ENTER KEY RESOURCE NAME to provide the resource name of the key that you want to use. For example, you can enter projects/my-project-name/locations/my-location/keyRings/my-keyring/cryptoKeys/my-key in the Key resource name field, and then click SAVE.

      Note:For more information about encryption keys, see CMEK for migration jobs.

9. Review the required prerequisites that are generated automatically to reflect how the environment must be prepared for a migration job. These prerequisites can include how to configure the source database and how to connect it to the destination Cloud SQL database instance. It's best to complete these prerequisites at this step, but you can complete them at any time before you test the migration job or start it. For more information about these prerequisites, see Configure your source Oracle database.

10. Click SAVE & CONTINUE.

Specify information about the source and destination connection profiles

1. Select your source and destination connection profiles from the Source connection profile and Destination connection profile drop-down lists.

2. Optional. Click VIEW DETAILS to see additional information about each connection profile.

3. Click RUN TEST for each connection profile to verify that Database Migration Service can communicate with both the source and the destination.

   If a test fails, then it indicates which part of the process had an issue. Necessary changes can be made and then re-tested.

   Navigate to the part of the flow in question to correct the issue, and then retest.

   Note: The migration job can be created even if tests for the source and destination connection profiles fail. However, you should fix any issues associated with the connection profiles before you create the migration job.

4. Click SAVE & CONTINUE.

Select objects to migrate

1. Select your conversion workspace from the Conversion workspace drop-down list.

2. Optional. Click VIEW DETAILS to see additional information about the conversion workspace.

   After you select a conversion workspace, the Select objects to migrate region of the page lists all objects (schemas and tables) from the Oracle source database that can be migrated into the destination.

3. Select the database objects from the list that you want Database Migration Service to migrate.

   To view the columns of a table, expand the schema node that's associated with the table, and then click VIEW COLUMNS.

4. Click SAVE & CONTINUE.

Test and create the migration job

On this final step, review the summary of the migration job settings, source, and destination, and then test the validity of the migration job setup. If any issues are encountered, then you can modify the migration job's settings. Not all settings are editable.

1. Click TEST JOB to verify that:

   • The source database has been configured correctly, based on the prerequisites.

   • Database Migration Service can connect to the destination database.

   • All converted tables are present in the destination database.

   • All converted tables in the destination database have a primary key.

   • None of the converted tables in the destination database has a foreign key. Foreign keys don't block the migration, however they impact the overall performance of the migration. If there are tables with foreign keys in the destination database, Database Migration Service issues a warning.

   If the test fails, then you can address the problem in the appropriate part of the flow, and return to re-test.

   For more information about reasons why the test may fail and how to troubleshoot any issues associated with the test failing, see Diagnose issues for Oracle to Cloud SQL for PostgreSQL.

   The migration job can be created even if the test fails, but after the job is started, it may fail at some point during the run.

2. Click CREATE & START JOB to create the migration job and start it immediately, or click CREATE JOB to create the migration job without immediately starting it.

   If the job isn't started at the time that it's created, then it can be started from the Migration jobs page by clicking START.

   Regardless of when the migration job starts, your organization is charged for the existence of the destination instance.

   Key Point: When you start the migration job, Database Migration Service begins the full dump, briefly locking the source database. If your source is in Amazon RDS or Amazon Aurora, Database Migration Service additionally requires a short (approximately under a minute) write downtime at the start of the migration.

   For more information, see Known limitations.

3. The migration job is added to the migration jobs list and can be viewed directly.