Manage connection profiles

Preview — Database Migration Service for homogeneous SQL Server migrations

This feature is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the Service Specific Terms. Pre-GA features are available "as is" and might have limited support. For more information, see the launch stage descriptions.

This page describes how to perform view, update, and delete operations for connection profiles.

View a connection profile

You can view the following information about your connection profiles:

• All configuration details provided during profile creation. For more information, see Connection profiles overview..

• Connection profile creation and last modification time.

• A list of migration jobs that use this connection profile.

To view connection profile details, perform the following steps:

Console

1. In the Google Cloud console, go to the Connection profiles page.

   Go to Connection profiles

2. Click the display name of the connection profile that you want to view.

   A connection profile overview page appears.

gcloud

Before using any of the command data below, make the following replacements:

• REGION with the identifier of the region where your connection profile is saved.
• CONNECTION_PROFILE_ID with your connection profile identifier.

  If you don't know the identifier, you can use the gcloud database-migration connection-profiles list command to list all profiles in a given region and view their identifiers.

For more information on these values, see Connection profiles overview.

Execute the following command:

Linux, macOS, or Cloud Shell

Note: Ensure you have initialized the Google Cloud CLI with authentication and a project by running either gcloud init; or gcloud auth login and gcloud config set project.

gcloud database-migration connection-profiles \
describe CONNECTION_PROFILE_ID \
  --region=REGION

Windows (PowerShell)

Note: Ensure you have initialized the Google Cloud CLI with authentication and a project by running either gcloud init; or gcloud auth login and gcloud config set project.

gcloud database-migration connection-profiles `
describe CONNECTION_PROFILE_ID `
  --region=REGION

Windows (cmd.exe)

Note: Ensure you have initialized the Google Cloud CLI with authentication and a project by running either gcloud init; or gcloud auth login and gcloud config set project.

gcloud database-migration connection-profiles ^
describe CONNECTION_PROFILE_ID ^
  --region=REGION

Update a connection profile

You can modify the following connection profile details:

• Display name
• (Source profile only) Cloud Storage bucket name
• (Destination profile only) destination Cloud SQL for SQL Server instance identifier

To update a connection profile, perform the following steps:

Console

1. In the Google Cloud console, go to the Connection profiles page.

   Go to Connection profiles

2. Click the display name of the connection profile that you want to modify.

   An overview page appears for the connection profile.

3. Click Edit and update your connection profile.
4. Click Save.

gcloud

This sample uses the optional --no-async flag so that all operations are performed synchronously. This means that some commands might take a while to complete. You can skip the --no-async flag to run commands asynchronously. If you do, you need to use the gcloud database-migration operations describe command to verify if your operation is successful.

Before using any of the command data below, make the following replacements:

• CONNECTION_PROFILE_ID with your connection profile identifier.

  If you don't know the identifier, you can use the gcloud database-migration connection-profiles list command to list all profiles in a given region and view their identifiers.

• REGION with the identifier of the region where your connection profile is saved.
• (Optional) CONNECTION_PROFILE_NAME with a human-readable name for your connection profile. This value is displayed in the Google Cloud console.
• (Optional, for source connection profiles only) SOURCE_STORAGE_BUCKET_ID with the Cloud Storage bucket name where you upload your full backup and transaction log files.
• (Optional, for destination connection profiles only) CLOUDSQL_INSTANCE_ID with the instance identifier of your destination Cloud SQL for SQL Server instance. For information on how to view Cloud SQL instance details, see View instance information in the Cloud SQL documentation.

For more information on these values, see Connection profiles overview.

Execute the following command:

Linux, macOS, or Cloud Shell

Note: Ensure you have initialized the Google Cloud CLI with authentication and a project by running either gcloud init; or gcloud auth login and gcloud config set project.

gcloud database-migration connection-profiles \
create sqlserver CONNECTION_PROFILE_ID \
  --no-async
  --region=REGION \
  --display-name=CONNECTION_PROFILE_NAME \
  --bucket=SOURCE_STORAGE_BUCKET_ID \
  --cloudsql-instance=CLOUDSQL_INSTANCE_ID

Windows (PowerShell)

Note: Ensure you have initialized the Google Cloud CLI with authentication and a project by running either gcloud init; or gcloud auth login and gcloud config set project.

gcloud database-migration connection-profiles `
create sqlserver CONNECTION_PROFILE_ID `
  --no-async
  --region=REGION `
  --display-name=CONNECTION_PROFILE_NAME `
  --bucket=SOURCE_STORAGE_BUCKET_ID `
  --cloudsql-instance=CLOUDSQL_INSTANCE_ID

Windows (cmd.exe)

Note: Ensure you have initialized the Google Cloud CLI with authentication and a project by running either gcloud init; or gcloud auth login and gcloud config set project.

gcloud database-migration connection-profiles ^
create sqlserver CONNECTION_PROFILE_ID ^
  --no-async
  --region=REGION ^
  --display-name=CONNECTION_PROFILE_NAME ^
  --bucket=SOURCE_STORAGE_BUCKET_ID ^
  --cloudsql-instance=CLOUDSQL_INSTANCE_ID

You should receive a response similar to the following:

Waiting for connection profile [CONNECTION_PROFILE_ID]
to be updated with [OPERATION_ID]

Waiting for operation [OPERATION_ID] to complete...done.

Created connection profile CONNECTION_PROFILE_ID [OPERATION_ID]

Delete a connection profile

You can delete a connection profile only if there are no migration jobs that use that profile. If you want to delete a connection profile that is in use by a migration job, first delete all migration jobs that are linked to the connection profile.

To delete a connection profile, perform the following steps:

Console

1. In the Google Cloud console, go to the Connection profiles page.

   Go to Connection profiles

2. Click the display name of the connection profile that you want to delete.

   A connection profile overview page appears.

3. Click Delete.
4. In the dialog, click Delete.

gcloud

This command returns an interactive confirmation prompt that requires your input to complete. You can skip the confirmation prompt by using the optional --quiet flag.

Before using any of the command data below, make the following replacements:

• REGION with the identifier of the region where your connection profile is saved.
• CONNECTION_PROFILE_ID with your connection profile identifier.

  If you don't know the identifier, you can use the gcloud database-migration connection-profiles list command to list all profiles in a given region and view their identifiers.

For more information on these values, see Connection profiles overview.

Execute the following command:

Linux, macOS, or Cloud Shell

Note: Ensure you have initialized the Google Cloud CLI with authentication and a project by running either gcloud init; or gcloud auth login and gcloud config set project.

gcloud database-migration connection-profiles \
delete CONNECTION_PROFILE_ID \
  --region=REGION

Windows (PowerShell)

Note: Ensure you have initialized the Google Cloud CLI with authentication and a project by running either gcloud init; or gcloud auth login and gcloud config set project.

gcloud database-migration connection-profiles `
delete CONNECTION_PROFILE_ID `
  --region=REGION

Windows (cmd.exe)

Note: Ensure you have initialized the Google Cloud CLI with authentication and a project by running either gcloud init; or gcloud auth login and gcloud config set project.

gcloud database-migration connection-profiles ^
delete CONNECTION_PROFILE_ID ^
  --region=REGION

Result

The delete returns an interactive prompt where you confirm the action. Enter Y to remove the connection profile:

You are about to delete connection_profile [CONNECTION_PROFILE_ID]

Do you want to continue (Y/n)?

You can skip Google Cloud CLI interactive confirmation prompts by using the optional --quiet flag.