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
In the Google Cloud console, go to Conversion workspaces.
From the list of available workspaces, select the one you want to work with.
Conversion workspace editor page appears.
Select Edit configuration > View details.
The Conversion workspace details panel opens.
gcloud
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.
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 workspaceREGION
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.
Go to the Conversion workspaces page in the Google Cloud console:
Click the display name of the conversion workspace that you want to modify.
The conversion workspace editor opens.
Select Edit configuration > View details.
The Conversion workspace details panel opens.
To modify the workspace display name:
- In the Conversion workspace name row, click the edit icon.
- In the Conversion workspace name field, enter the new display name for the conversion workspace.
- Click Save.
To modify the source connection profile:
- In the Source connection profile row, click the link to the connection profile associated with the workspace.
- 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.
To modify the Ora2Pg configuration files:
On the conversion editor page, select Edit configuration > Customize mapping with a configuration file.
In the Ora2Pg configuration file box, click Browse and use the system file picker to select your configuration file.
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.
In the Google Cloud console, go to Conversion workspaces.
Next to the conversion workspace you want to delete, click > Delete.
MoreIn the dialog confirmation box, click Delete.