Manage conversion workspaces

This page describes how to manage multiple conversion workspaces in your projects.

From the list of conversion workspaces, you can:

  • Select a specific conversion workspace to access the conversion editor, view and modify workspace details, apply generated schema and code to your destination database, and create a migration job.

  • Use the More menu, to delete select workspaces.

View conversion workspace details

To view conversion workspace details, use the Conversion workspaces page in the Google Cloud console or Google Cloud CLI.

Console

  1. In the Google Cloud console, go to Conversion workspaces.

    Go to Conversion workspaces

  2. From the list of available workspaces, select the one you want to work with.

    Conversion workspace editor page appears.

  3. Select Edit configuration > View details.

The Conversion workspace details panel opens.

gcloud

  1. List all workspaces available in a particular region to retrieve their identifiers:

    gcloud database-migration conversion-workspaces list \
        --region=REGION
    

    Replace:

    • REGION with the name of the region where the conversion workspace is located.

    Example:

    gcloud database-migration conversion-workspaces list \
        --region=us-central1
    

    The list of available workspaces and their identifiers is printed to standard output.

  2. Retrieve details for a specific workspace:

    gcloud database-migration conversion-workspaces describe CONVERSION_WORKSPACE \
      --region=REGION
    

    Replace:

    • CONVERSION_WORKSPACE with the identifier or the fully qualified name of the conversion workspace

    • REGION with the name of the region where the conversion workspace is located.

    Example:

    gcloud database-migration conversion-workspaces describe my-conversion-workspace-id \
      --region=us-central1
    

Modify conversion workspace settings

Information that you can modify for a conversion workspace includes the display name, source connection profile, and Ora2Pg configuration files.

  1. Go to the Conversion workspaces page in the Google Cloud console:

    Go to Conversion workspaces

  2. Click the display name of the conversion workspace that you want to modify.

    The conversion workspace editor opens.

  3. Select Edit configuration > View details.

    The Conversion workspace details panel opens.

  4. To modify the workspace display name:

    1. In the Conversion workspace name row, click the edit icon.
    2. In the Conversion workspace name field, enter the new display name for the conversion workspace.
    3. Click Save.
  5. To modify the source connection profile:

    1. In the Source connection profile row, click the link to the connection profile associated with the workspace.
    2. On the connection profile page, adjust any details as required. For more information, see Manage connection profiles. A new version of the conversion workspace is created and the updated version ID also appears on the overview page. This version can be used with a migration job.
  6. To modify the Ora2Pg configuration files:

    1. On the conversion editor page, select Edit configuration > Customize mapping with a configuration file.

    2. In the Ora2Pg configuration file box, click Browse and use the system file picker to select your configuration file.

    3. Click Add file > Generate.

Delete a conversion workspace

You can delete a conversion workspace only if it's not used by active migration jobs.

To delete a conversion workspace that's linked to active migration jobs, first, delete all active migration jobs that are linked to the conversion workspace. Then, delete the conversion workspace.

  1. In the Google Cloud console, go to Conversion workspaces.

    Go to Conversion workspaces

  2. Next to the conversion workspace you want to delete, click More > Delete.

  3. In the dialog confirmation box, click Delete.