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 a workspace.

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

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

    Conversion workspace editor page appears.

  2. 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, add or remove custom conversion 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. You can also modify what custom conversion mapping files are used in your workspace. For more information, see Use custom conversion mappings.

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.

Review all conversion workspaces

You can review all conversion workspaces from the page. The list displays a default set of high-level information for each conversion workspace, including:

  • The conversion workspace display name and ID.
  • The version ID of the most-recent version of the conversion workspace that's saved. By having multiple versions of a conversion workspace, you can compare objects in each workspace and identify differences between the workspaces. Versioning can also be used for tracking purposes.
  • The conversion state that represents whether this conversion workspace was used to pull objects from the source and convert them.
  • Activity indicates if the conversion workspace is in use by one or more active migration jobs, where an active migration job is any migration job that's not in COMPLETED status. The number of jobs next to the status indicates the total number of jobs (both active and inactive) referencing the conversion workspace.
  • The source and destination database engines (database types) for which the conversion workspace is configured.
  • When the conversion workspace was created.