Create a source connection profile

To create a source connection profile, follow these steps:

Console

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

    Go to Connection profiles

  2. Click Create profile.
  3. From the Database engine list, select SQL Server.
  4. Supply the following information for your connection profile:
    • Connection profile name.
    • Connection profile ID.
    • Region.
    • The Cloud Storage bucket that contains the parent database folder where you create the full, diff, and logs folders (that hold the full backup, differential backup, and transaction log files).

    For more information about connection profile fields, see Connection profiles overview.

  5. Optional: In the Test connection profile section, click Run test.

    Database Migration Service performs a quick check to verify that the connection details you supplied are sufficient to reach your data.

  6. Click Create at the bottom of the page.

    The Connection profiles page appears, and the newly created connection profile is displayed.

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 a machine-readable identifier for your connection profile.
  • REGION with the identifier of the region where you want to save the connection profile.
  • CONNECTION_PROFILE_NAME with a human-readable name for your connection profile. This value is displayed in Database Migration Service in the Google Cloud console.
  • SOURCE_STORAGE_BUCKET_NAME with the Cloud Storage bucket name that contains the parent database folder where you create the full, diff, and logs folders (that hold the full backup, differential backup, and transaction log files).
For more information on these values, see Connection profiles overview.

Execute the following command:

Linux, macOS, or Cloud Shell

gcloud database-migration connection-profiles \
create sqlserver CONNECTION_PROFILE_ID \
  --no-async
  --display-name=CONNECTION_PROFILE_NAME \
  --gcs-bucket=SOURCE_STORAGE_BUCKET_NAME \
  --region=REGION

Windows (PowerShell)

gcloud database-migration connection-profiles `
create sqlserver CONNECTION_PROFILE_ID `
  --no-async
  --display-name=CONNECTION_PROFILE_NAME `
  --gcs-bucket=SOURCE_STORAGE_BUCKET_NAME `
  --region=REGION

Windows (cmd.exe)

gcloud database-migration connection-profiles ^
create sqlserver CONNECTION_PROFILE_ID ^
  --no-async
  --display-name=CONNECTION_PROFILE_NAME ^
  --gcs-bucket=SOURCE_STORAGE_BUCKET_NAME ^
  --region=REGION

You should receive a response similar to the following:

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

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

Created connection profile CONNECTION_PROFILE_ID [OPERATION_ID]