Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Detail koneksi yang perlu Anda berikan dapat berbeda bergantung pada konektivitas tujuan yang Anda gunakan. Halaman ini menjelaskan cara membuat profil koneksi tujuan
untuk setiap metode konektivitas yang tersedia:
Sebelum membuat profil koneksi tujuan, pastikan Anda melakukan hal berikut:
Pertimbangkan region tempat Anda ingin membuat profil koneksi tujuan.
Database Migration Service adalah produk yang sepenuhnya regional, yang berarti semua entitas yang terkait dengan migrasi Anda (profil koneksi sumber dan tujuan, tugas migrasi, database tujuan, ruang kerja konversi) harus disimpan dalam satu region.
Di bagian Tentukan metode konektivitas, dari menu drop-down
Metode konektivitas, pilih IP Publik.
Klik Simpan.
Panel detail koneksi ditutup.
(Opsional) Di bagian Test connection profile, klik Run test.
Database Migration Service melakukan pemeriksaan cepat untuk memverifikasi bahwa detail koneksi yang Anda berikan sudah cukup untuk menjangkau data Anda.
Klik Create di bagian bawah halaman.
Halaman Profil koneksi akan muncul, dan profil koneksi yang baru
dibuat akan ditampilkan.
Di kolom Port, masukkan nomor port database. Default untuk
PostgreSQL adalah 5432.
Di kolom Nama Pengguna dan Sandi, masukkan detail
login untuk akun pengguna migrasi khusus.
Di kolom Database name, masukkan nama database tujuan Anda. Jika Anda tidak memberikan nama, Database Migration Service akan menggunakan nama yang sama dengan akun pengguna migrasi khusus Anda.
(Opsional) Di bagian Test connection profile, klik Run test.
Database Migration Service melakukan pemeriksaan cepat untuk memverifikasi bahwa detail koneksi yang Anda berikan sudah cukup untuk menjangkau data Anda.
Klik Create di bagian bawah halaman.
Halaman Profil koneksi akan muncul, dan profil koneksi yang baru
dibuat akan ditampilkan.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-09-08 UTC."],[],[],null,["# Create a destination connection profile\n\nThe connection details you need to provide can differ depending on what destination\nconnectivity you use. This page describes how to create destination connection profiles\nfor each available connectivity method:\n\n- [Destination connection profile for public IP connectivity](#public-ip-connectivity)\n\n- [Destination connection profile for private IP connectivity](#private-ip-connectivity)\n\nBefore you begin\n----------------\n\nBefore you create a destination connection profile, make sure you do the following:\n\n1. Consider in which region you want to create the destination connection profile.\n\n Database Migration Service is a fully-regional product, meaning all entities\n related to your migration (source and destination connection profiles,\n migration jobs, destination databases, conversion workspaces) must be\n saved in a single region.\n2. [Configure your destination database and create a dedicated migration user account](/database-migration/docs/oracle-to-postgresql/configure-your-destination-postgresql-database).\n\n3. [Choose and configure the destination connectivity method](/database-migration/docs/oracle-to-postgresql/networking-methods-destination).\n\n Destination database connections are always encrypted by Database Migration Service.\n You don't need to configure additional certificates for those connections.\n\nFor public IP connectivity\n--------------------------\n\nTo create a destination connection profile that uses the\n[public IP connectivity method](/database-migration/docs/oracle-to-postgresql/networking-methods-destination#public-ip), follow these steps:\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. From the **Database engine** list, select **Cloud SQL for PostgreSQL**.\n4. In the **Specify connection profile details** section, provide the connection profile name, identifier, and region.\n5. In the **Define connection configurations** , in the **SQL Server or Oracle to PostgreSQL** card, click **Define** .\n\n The connectivity details panel opens.\n6. In the **Define connection details** panel, do the following:\n 1. From the **Instance ID** drop-down menu, select your Cloud SQL destination instance identifier.\n 2. In the **Hostname and IP** field, enter your destination instance's public IP address.\n 3. In the **Port** field, enter the database port number. The default for PostgreSQL is `5432`.\n 4. In the **Username** and **Password** fields, enter the login details for the dedicated migration user account.\n 5. In the **Database name** field, enter the name of your destination database.\n 6. You create the dedicated migration user account and the destination database during the [destination database preparation step](/database-migration/docs/oracle-to-postgresql/configure-your-destination-postgresql-database).\n 7. In the **Define connectivity method** section, from the **Connectivity method** drop-down menu, select **Public IP**.\n 8. Click **Save**.\n\n The connection details panel closes.\n7. (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.\n8. 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\nFor private IP connectivity\n---------------------------\n\nTo create a destination connection profile that uses the\n[private IP with Private Service Connect connectivity method](/database-migration/docs/oracle-to-postgresql/networking-methods-destination#private-ip),\nfollow these steps:\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. From the **Database engine** list, select **Cloud SQL for PostgreSQL**.\n4. In the **Specify connection profile details** section, provide the connection profile name, identifier, and region.\n5. In the **Define connection configurations** , in the **SQL Server or Oracle to PostgreSQL** card, click **Define** .\n\n The connectivity details panel opens.\n6. In the **Define connection details** panel, do the following:\n 1. From the **Instance ID** drop-down menu, select your Cloud SQL destination instance identifier.\n 2. In the **Hostname and IP** field, enter the [DNS name configured for your instance](/sql/docs/postgres/about-private-service-connect#dns-name-record).\n 3. In the **Port** field, enter the database port number. The default for PostgreSQL is `5432`.\n 4. In the **Username** and **Password** fields, enter the login details for the dedicated migration user account.\n 5. In the **Database name** field enter the name of your destination database. If you don't provide a name, Database Migration Service uses the same name as your dedicated migration user account.\n 6. You create the dedicated migration user account and the destination database during the [destination database preparation step](/database-migration/docs/oracle-to-postgresql/configure-your-destination-postgresql-database).\n 7. In the **Define connectivity method** section, do the following:\n 1. From the **Connectivity method** drop-down menu, select **Private IP**.\n 2. From the **Service attachment name** select the service attachment [you created for the destination instance Private Service Connect\n connection](/database-migration/docs/oracle-to-postgresql/configure-dst-connection-private-ip#non-psc).\n 8. Click **Save**.\n\n The connection details panel closes.\n7. (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.\n8. Click **Create** at the bottom of the page.\n\n The **Connection profiles** page appears, and the newly\n created connection profile is displayed."]]