Sauf indication contraire, le contenu de cette page est régi par une licence Creative Commons Attribution 4.0, et les échantillons de code sont régis par une licence Apache 2.0. Pour en savoir plus, consultez les Règles du site Google Developers. Java est une marque déposée d'Oracle et/ou de ses sociétés affiliées.
Dernière mise à jour le 2025/09/05 (UTC).
[[["Facile à comprendre","easyToUnderstand","thumb-up"],["J'ai pu résoudre mon problème","solvedMyProblem","thumb-up"],["Autre","otherUp","thumb-up"]],[["Difficile à comprendre","hardToUnderstand","thumb-down"],["Informations ou exemple de code incorrects","incorrectInformationOrSampleCode","thumb-down"],["Il n'y a pas l'information/les exemples dont j'ai besoin","missingTheInformationSamplesINeed","thumb-down"],["Problème de traduction","translationIssue","thumb-down"],["Autre","otherDown","thumb-down"]],["Dernière mise à jour le 2025/09/05 (UTC)."],[[["\u003cp\u003eThis content outlines the steps to create a destination connection profile for Cloud SQL for SQL Server, using either the Google Cloud console or the \u003ccode\u003egcloud\u003c/code\u003e command-line tool.\u003c/p\u003e\n"],["\u003cp\u003eWhen using the Google Cloud console, navigate to the \u003cstrong\u003eConnection profiles\u003c/strong\u003e page, select \u003cstrong\u003eDestination\u003c/strong\u003e as the profile role, and choose \u003cstrong\u003eCloud SQL for SQL Server\u003c/strong\u003e as the database engine before inputting required connection details.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003egcloud\u003c/code\u003e method involves executing a command that includes specifying a connection profile ID, region, connection profile name, Cloud SQL instance ID, migration username, and password.\u003c/p\u003e\n"],["\u003cp\u003eTesting the connection profile via the \u003cstrong\u003eRun test\u003c/strong\u003e option in the console or using the \u003ccode\u003e--no-async\u003c/code\u003e flag with the \u003ccode\u003egcloud\u003c/code\u003e command allows for immediate verification of the connection's success.\u003c/p\u003e\n"]]],[],null,["# Create a destination connection profile\n\nTo create a destination connection profile for your Cloud SQL for SQL Server\ninstance, follow these steps: \n\n### Console\n\n1. In the Google Cloud console, go to the **Connection profiles** page.\n\n [Go to Connection profiles](https://console.cloud.google.com/dbmigration/connection-profiles)\n2. Click **Create profile**.\n3. On the **Create a connection profile** page, from the **Profile role** list, select **Destination**.\n4. From the **Database engine** list, select **Cloud SQL for SQL Server**.\n5. Supply the following information for your connection profile:\n - Connection profile name\n - Connection profile ID\n - Region\n - Migration database username and password\n\n For more information on these fields, see\n [Connection profiles overview](/database-migration/docs/sqlserver/about-connection-profiles).\n6. Optional: In the **Test connection profile** section, click **Run test** .\n\n Database Migration Service performs a quick check to verify that\n the connection details you supplied are sufficient to reach\n your data.\n7. Click **Create** at the bottom of the page.\n\n The **Connection profiles** page appears, and the newly\n created connection profile is displayed.\n\n### gcloud\n\nThis sample uses the optional `--no-async` flag so that all operations\nare performed synchronously. This means that some commands might take\na while to complete. You can skip the `--no-async` flag to run commands asynchronously.\nIf you do, you need to use the\n[`gcloud database-migration operations describe`](/sdk/gcloud/reference/database-migration/migration-jobs/describe)\ncommand to verify if your operation is successful.\n\n\nBefore using any of the command data below,\nmake the following replacements:\n\n- \u003cvar class=\"edit\" scope=\"CONNECTION_PROFILE_ID\" translate=\"no\"\u003eCONNECTION_PROFILE_ID\u003c/var\u003e with a machine-readable identifier for your connection profile.\n- \u003cvar class=\"edit\" scope=\"REGION\" translate=\"no\"\u003eREGION\u003c/var\u003e with the identifier of the region where you want to save the connection profile.\n- \u003cvar class=\"edit\" scope=\"CONNECTION_PROFILE_NAME\" translate=\"no\"\u003eCONNECTION_PROFILE_NAME\u003c/var\u003e with a human-readable name for your connection profile. This value is displayed in Database Migration Service in the Google Cloud console.\n- \u003cvar class=\"edit\" scope=\"CLOUDSQL_INSTANCE_ID\" translate=\"no\"\u003eCLOUDSQL_INSTANCE_ID\u003c/var\u003e 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](/sql/docs/sqlserver/instance-info) in the Cloud SQL documentation.\n- **Migration user details** : Provide the details for the dedicated database user account in your destination instance. For more information on this user account, see [Create and configure the Cloud SQL for SQL Server destination instance](/database-migration/docs/sqlserver/create-cloud-sql-destination-instance).\n - \u003cvar class=\"edit\" scope=\"CLOUD_SQL_DB_USERNAME\" translate=\"no\"\u003eCLOUD_SQL_DB_USERNAME\u003c/var\u003e with the migration user name.\n - \u003cvar class=\"edit\" scope=\"CLOUD_SQL_DB_USER_PASSWORD\" translate=\"no\"\u003eCLOUD_SQL_DB_USER_PASSWORD\u003c/var\u003e with the password for the migration account.\n\nFor more information on these values, see [Connection profiles overview](/database-migration/docs/sqlserver/about-connection-profiles).\n\n\nExecute the\n\nfollowing\n\ncommand:\n\n#### Linux, macOS, or Cloud Shell\n\n**Note:** Ensure you have initialized the Google Cloud CLI with authentication and a project by running either [gcloud init](/sdk/gcloud/reference/init); or [gcloud auth login](/sdk/gcloud/reference/auth/login) and [gcloud config set project](/sdk/gcloud/reference/config/set). \n\n```bash\ngcloud database-migration connection-profiles \\\ncreate sqlserver CONNECTION_PROFILE_ID \\\n --no-async\n --display-name=CONNECTION_PROFILE_NAME \\\n --cloudsql-instance=CLOUDSQL_INSTANCE_ID \\\n --region=REGION \\\n --username=CLOUD_SQL_DB_USERNAME\n --password=CLOUD_SQL_DB_USER_PASSWORD\n```\n\n#### Windows (PowerShell)\n\n**Note:** Ensure you have initialized the Google Cloud CLI with authentication and a project by running either [gcloud init](/sdk/gcloud/reference/init); or [gcloud auth login](/sdk/gcloud/reference/auth/login) and [gcloud config set project](/sdk/gcloud/reference/config/set). \n\n```bash\ngcloud database-migration connection-profiles `\ncreate sqlserver CONNECTION_PROFILE_ID `\n --no-async\n --display-name=CONNECTION_PROFILE_NAME `\n --cloudsql-instance=CLOUDSQL_INSTANCE_ID `\n --region=REGION `\n --username=CLOUD_SQL_DB_USERNAME\n --password=CLOUD_SQL_DB_USER_PASSWORD\n```\n\n#### Windows (cmd.exe)\n\n**Note:** Ensure you have initialized the Google Cloud CLI with authentication and a project by running either [gcloud init](/sdk/gcloud/reference/init); or [gcloud auth login](/sdk/gcloud/reference/auth/login) and [gcloud config set project](/sdk/gcloud/reference/config/set). \n\n```bash\ngcloud database-migration connection-profiles ^\ncreate sqlserver CONNECTION_PROFILE_ID ^\n --no-async\n --display-name=CONNECTION_PROFILE_NAME ^\n --cloudsql-instance=CLOUDSQL_INSTANCE_ID ^\n --region=REGION ^\n --username=CLOUD_SQL_DB_USERNAME\n --password=CLOUD_SQL_DB_USER_PASSWORD\n```\n\nYou should receive a response similar to the following:\n\n```\nWaiting for connection profile [CONNECTION_PROFILE_ID]\nto be created with [OPERATION_ID]\n\nWaiting for operation [OPERATION_ID] to complete...done.\n\nCreated connection profile CONNECTION_PROFILE_ID [OPERATION_ID]\n```"]]
