Connection profiles capture identifiers for your data sources and destination databases. Each connection profile contains the minimum required amount of information Database Migration Service needs to facilitate data movement between the data source and destination.
That information includes:
Connection profile name: A human-readable name for your connection profile. This value is displayed in Database Migration Service in the Google Cloud console.
Connection profile ID: A machine-readable identifier for your connection profile. This value is used when you work with connection profiles by using Database Migration Service Google Cloud CLI commands or API.
Region: The region where your connection profile is saved. Database Migration Service is a fully-regional product, meaning all entities related to your migration (source and destination connection profiles, migration jobs, destination databases) must be saved in a single region. For more information on region requirements in Database Migration Service, see Product overview in the main Database Migration Service documentation set.
For source connection profiles: Backup files location: The Cloud Storage bucket where you upload the SQL Server backup and transaction log files that Database Migration Service transfers to your destination database.
For destination connection profiles:
Destination instance ID: The identifier of your Cloud SQL for SQL Server destination instance where Database Migration Service transfers the data from the backup files stored in the Cloud Storage bucket.
Username and password for the migration database user in your destination instance. For more information on this user account, see Create and configure the Cloud SQL for SQL Server destination instance.
What's next
- Create a source connection profile
- Create a destination connection profile
- Manage connection profiles