> [!WARNING]
>
> **Preview**
>
>
> This feature is
>
> subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the
> [Service Specific
> Terms](https://docs.cloud.google.com/terms/service-terms#1).
>
> Pre-GA features are available "as is" and might have limited support.
>
> For more information, see the
> [launch stage descriptions](https://cloud.google.com/products/#product-launch-stages).

To simplify homogeneous PostgreSQL migrations to AlloyDB for PostgreSQL, you
can use quick-start migrations in Database Migration Service to automatically
provision network connectivity, connection profiles, and continuous replication
jobs.

## Overview

*Quick-start migrations* are a lightweight continuous migration flow for homogeneous
PostgreSQL scenarios. With quick-start migrations, Database Migration Service
can automatically set up everything you need to migrate your databases:
networking components (network attachments, subnets, private
connectivity configurations), connection profiles, and migration jobs.

With quick-start migrations, you can move your data to an existing AlloyDB for PostgreSQL
cluster, or create a new one as you configure the migration.
Quick-start migrations are best suited for:

- Basic migrations, where you don't need precise control over data dump parallelism settings.
- Migrating your database from one Google Cloud project to another. When you configure a quick-start migration, you can create your destination cluster in a different project than your source and set Database Migration Service to create the network attachment and subnet in the Virtual Private Cloud (VPC) network of another project.
- Migrating from sources that have a private IP address in your Google Cloud
  Virtual Private Cloud (VPC) network, such as self-managed databases on
  Compute Engine, or Cloud SQL for PostgreSQL instances enabled for private networking.

  Sources hosted outside Google Cloud might need additional network components
  (such as a Cloud VPN connection) so that they can be reached at a private
  IP address within your VPC network.
- The source database must have a private IP address assigned in your VPC network. Database Migration Service connects to the source database using Private Service Connect interfaces (network attachments). Public IP connectivity isn't supported for quick-start migrations.

To learn more about quick-start migrations, see
[Quick-start migrations](https://docs.cloud.google.com/database-migration/docs/about-quick-start-migrations.md.txt)
in the Database Migration Service documentation.

## Before you begin

1. Verify if quick-start migrations can fully support your scenario. See [Quick-start migration limitations](https://docs.cloud.google.com/database-migration/docs/about-quick-start-migrations.md.txt#limitations) in the Database Migration Service documentation.
2. Enable the Database Migration Service, Compute Engine, Network Connectivity Center, and AlloyDB for PostgreSQL Admin APIs.
   [Enable the APIs](https://console.cloud.google.com/apis/enableflow?apiid=compute.googleapis.com,datamigration.googleapis.com,alloydb.googleapis.com,networkconnectivity.googleapis.com)

### Required roles

To get the permissions that you need to run quick-start migrations to AlloyDB for PostgreSQL
with Database Migration Service, ask your administrator to grant the
required Identity and Access Management (IAM) roles for the accounts involved in the
migration in the relevant projects. For more information about granting roles, see
[Manage access](https://docs.cloud.google.com/iam/docs/granting-changing-revoking-access.md.txt)
in the IAM documentation.

> [!IMPORTANT]
> **Important:** You must assign the roles directly to these accounts. Roles inherited through Google group membership aren't supported for quick-start migrations.

#### Roles and permissions in the source project

Grant the following roles to specific accounts on the Google Cloud project
where your **source** database resides:

- For the user account that performs the migration: [Compute Network Admin](https://docs.cloud.google.com/iam/docs/roles-permissions/compute.md.txt#compute.networkAdmin) (`roles/compute.networkAdmin`)
- For the Database Migration Service service account of the **destination** project: [Compute Network Viewer](https://docs.cloud.google.com/iam/docs/roles-permissions/compute.md.txt#compute.networkViewer) (`roles/compute.networkViewer`)

  The Database Migration Service service account is created for you when you enable the
  Database Migration Service API. The email address associated with this account is generated
  automatically and can't be changed. This email address uses the following
  format:

  ```bash
  service-DESTINATION_PROJECT_NUMBER@gcp-sa-datamigration.iam.gserviceaccount.com
  ```

These predefined roles contain the permissions required to set up connectivity
on your **source** database project as part of a quick-start migration with
Database Migration Service. To see the exact permissions that are required, expand the
**Required permissions (source)** section:

#### Required permissions (source)

The following permissions are required to perform homogeneous quick-start
migrations with Database Migration Service:

For the user account that performs the migration:

- `compute.networks.*`
- `compute.subnetworks.*`
- `compute.networkAttachments.*`

For the Database Migration Service service account of the **destination** project:
`compute.networkAttachments.get`.

#### Roles and permissions in the destination project

Grant the following roles to the user account that performs the migration
on the Google Cloud project where your **destination** database resides:

- [Database Migration Admin](https://docs.cloud.google.com/iam/docs/roles-permissions/datamigration.md.txt#datamigration.admin) (`roles/datamigration.admin`)
- [AlloyDB Admin](https://docs.cloud.google.com/iam/docs/roles-permissions/alloydb.md.txt#alloydb.admin) (`roles/alloydb.admin`)

These predefined roles contain the permissions required to set up the required
migration components on your **destination** database project as part of
a quick-start migration with Database Migration Service. To see the exact
permissions that are required, expand the
**Required permissions (destination)** section:

#### Required permissions (destination)

The following permissions are required to perform homogeneous quick-start
migrations with Database Migration Service:

- `datamigration.*`
- `alloydb.clusters.create`
- `alloydb.clusters.get`
- `alloydb.clusters.list`
- `alloydb.clusters.update`
- `alloydb.clusters.delete`
- `alloydb.instances.create`
- `alloydb.instances.get`
- `alloydb.instances.list`
- `alloydb.instances.update`
- `alloydb.instances.delete`
- `alloydb.instances.executeSql`
- `alloydb.operations.get`
- `alloydb.users.list`
- `alloydb.users.get`
- `alloydb.users.create`
- `alloydb.users.update`
- `alloydb.users.delete`

## Configure your source database

To configure your source PostgreSQL database, do the following:

1. Create a dedicated migration user account in your instance.
   - For Cloud SQL for PostgreSQL sources, see [Create a user](https://docs.cloud.google.com/sql/docs/postgres/create-manage-users.md.txt#creating) in the Cloud SQL documentation.
   - For other sources, see your database provider documentation or [create and manage users](https://www.postgresql.org/docs/current/sql-createuser.html) in the PostgreSQL documentation.
2. Assign the necessary privileges to the dedicated migration user account. Run the following commands for each database you want to migrate:

   ```sql
   -- Grant the REPLICATION attribute
   ALTER ROLE MIGRATION_USER REPLICATION;

   -- Grant database-level permissions.
   -- Repeat for each database you want to migrate.
   GRANT CONNECT, CREATE ON DATABASE DATABASE_NAME TO MIGRATION_USER;

   -- Grant schema-level usage.
   -- Repeat for each schema in each database you want to migrate.
   GRANT USAGE ON SCHEMA SCHEMA_NAME TO MIGRATION_USER;
   ```

   Replace the following:
   - <var translate="no">MIGRATION_USER</var> with the name of the migration user account.
   - <var translate="no">DATABASE_NAME</var> with the name of the database you want to migrate.
   - <var translate="no">SCHEMA_NAME</var> with the name of the schema in the database you want to migrate.
3. The migration user account needs to have ownership access to the tables you migrate. To grant this level of access, do one of the following:
   - For sources other than Cloud SQL for PostgreSQL only: Assign the [`SUPERUSER` PostgreSQL role](https://www.postgresql.org/docs/current/role-attributes.html#id-1.6.8.6.2.1.2.1.1) to the migration account.
   - For all sources: Add the migration user account to the user group that owns the tables. Run the following command:

     ```sql
     -- Grant table ownership.
     GRANT TABLE_OWNER_GROUP_NAME TO MIGRATION_USER;
     ```

     Replace the following:
     - <var translate="no">TABLE_OWNER_GROUP_NAME</var> with the name of the user group that owns each table that you want to migrate.
     - <var translate="no">MIGRATION_USER</var> with the name of the migration user account.
4. **For tables that don't have primary keys** : By default, only `INSERT` operations are replicated for tables without primary keys during the Change Data Capture (CDC) phase. To replicate `UPDATE` and `DELETE` operations, you must set the table's [`REPLICA IDENTITY`](https://www.postgresql.org/docs/current/logical-replication-publication.html#LOGICAL-REPLICATION-PUBLICATION-REPLICA-IDENTITY) to `FULL` or `USING INDEX`:

   ```sql
   ALTER TABLE TABLE_NAME REPLICA IDENTITY FULL;
   ALTER TABLE TABLE_NAME REPLICA IDENTITY USING INDEX INDEX_NAME;
   ```

   Replace the following:
   - <var translate="no">TABLE_NAME</var> is the name of the table that doesn't have primary keys.
   - <var translate="no">INDEX_NAME</var> is the unique index that can track rows from tables without primary keys.
5. Configure the replication settings using database flags.

   ### Self-managed sources

   Saving changes to database flags requires a full database restart.
   The following examples use SQL queries for changing flag values.
   If you can't run SQL queries directly, refer to your provider documentation
   for steps about changing these flags.
   1. Set the [`wal_level`](https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-WAL-LEVEL) parameter to `logical`. Run the following command:

      ```sql
      ALTER SYSTEM SET wal_level = 'logical';
      ```
   2. Set the [`wal_sender_timeout`](https://www.postgresql.org/docs/current/runtime-config-replication.html#GUC-WAL-SENDER-TIMEOUT) parameter to `0`. This value disables the timeout mechanism that's used to terminate inactive replication connections. Run the following command:

      ```sql
      ALTER SYSTEM SET wal_sender_timeout = 0;
          
      ```
   3. Configure the maximum number of replication slots with the [`max_replication_slots`](https://www.postgresql.org/docs/current/runtime-config-replication.html#GUC-MAX-REPLICATION-SLOTS) parameter. This parameter must be set to at least the number of databases you're migrating per migration job, plus some reserves for table synchronization.


      For example, if you're migrating 5 databases and there are 2 migration
      jobs created for the source instance, then the number of replication slots
      must be at least `5 * 2 = 10`, plus the number of replication
      slots already used by you.

      To set this parameter, run the following command:

      ```sql
      ALTER SYSTEM SET max_replication_slots = NUMBER_OF_SLOTS;
          
      ```
      Where <var translate="no">NUMBER_OF_SLOTS</var> represents the maximum number of replication slots.
   4. Configure the [`max_wal_senders`](https://www.postgresql.org/docs/current/runtime-config-replication.html#GUC-MAX-WAL-SENDERS) parameter to at least the same value as `max_replication_slots`, plus the number of senders already used on your instance.

      For example, if the `max_replication_slots` parameter is set
      to `10`, and you're already using 2 senders, then the number of
      WAL sender processes running at the same time would be `10 + 2 = 12`.

      To set this parameter, run the following command:

      ```sql
      ALTER SYSTEM SET max_wal_senders = NUMBER_OF_SENDERS;
          
      ```
      Where <var translate="no">NUMBER_OF_SENDERS</var> represents the number of WAL sender processes running simultaneously.
   5. Set the [`max_worker_processes`](https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-MAX-WORKER-PROCESSES) to at least the number of databases that you want to migrate, plus the number of `max_worker_processes` already used on your instance. To set this parameter, run the following command:

      ```sql
      ALTER SYSTEM SET max_worker_processes = NUMBER_OF_PROCESSES;
          
      ```
      Where <var translate="no">NUMBER_OF_PROCESSES</var> represents the number of databases that will be migrated.

   ### Cloud SQL for PostgreSQL sources

   For Cloud SQL sources, you configure database flags in the Google Cloud console.
   You have to restart your instance after modifying database flags for the
   setting to take effect. For more information on setting database flags in
   Cloud SQL, see
   [Configure database flags](https://docs.cloud.google.com/sql/docs/postgres/flags.md.txt)
   in the Cloud SQL documentation.
   1. Set the `cloudsql.logical_decoding` flag to `on`.
   2. Set the `wal_sender_timeout` parameter to `0`. This value disables the timeout mechanism that's used to terminate inactive replication connections.
   3. Configure the maximum number of replication slots with the `max_replication_slots` parameter. This parameter must be set to at least the number of databases you're migrating per migration job, plus some reserves for table synchronization.


      For example, if you're migrating 5 databases and there are 2 migration
      jobs created for the source instance, then the number of replication slots
      must be at least `5 * 2 = 10`, plus the number of replication
      slots already used by you.
   4. Configure the `max_wal_senders` parameter to at least the same value as `max_replication_slots`, plus the number of senders already used on your instance.

      For example, if the `max_replication_slots` parameter is set
      to `10`, and you're already using 2 senders, then the number of
      WAL sender processes running at the same time would be `10 + 2 = 12`.
   5. Set the `max_worker_processes` parameter to at least the number of databases that you want to migrate, plus the number of `max_worker_processes` already used on your instance.

## Create and run a quick-start migration

When you use quick-start migrations, you can create a new AlloyDB for PostgreSQL
cluster and migrate your databases there, or migrate databases to a cluster that
already exists.

### Quick-start migrations for new clusters

To create a new AlloyDB for PostgreSQL cluster and immediately migrate your
databases there, follow these steps:

### Console

1. Go to the **Clusters** page.


   [Go to Clusters](https://console.cloud.google.com/alloydb/clusters)
2. Click **Create cluster** \> **From an existing database**

   The Database Migration Service quick-start migration form opens.
3. In the **Configure migration** section, do the following:
   1. From the **Destination region** menu, select the region of your destination AlloyDB for PostgreSQL cluster.
   2. In the **Migration prefix** box, enter a string that will be added to the names of all migration entities created for the quick-start migration: connection profiles, private connectivity configuration, network attachment and its subnet, and migration job.
   3. From the **Configuration type** menu, select one of the following:
      1. **Existing connectivity configuration**: Select this option if you already have a network attachment and a private connectivity configuration that uses Private Service Connect interfaces method. This option is best used if you previously used quick-start migrations and want to re-use the same networking resources.
      2. **New connectivity configuration**: Select this option to create a new network attachment and the network attachment subnet in the source database VPC network. The private connectivity configuration will be created in the same project as your destination cluster.
   4. Click **Continue**.
4. In the **Connect source** section, do the following:
   1. Enter a **Hostname** or the private **IP address** of your source database. The source database address must be reachable from your source VPC network.
   2. Enter the **Port** that's used to access the host. The default PostgreSQL port number is `5432`.
   3. Enter the username and password for the dedicated migration account in your source database.
   4. From the **Encryption type** menu, select one of the following:
      - **None**: If your source database doesn't require SSL/TLS-encrypted connections.
      - **Required**: If your source database requires SSL/TLS-encrypted connections. This option doesn't require any certificate verification.
   5. In the **Databases to migrate** menu, click **Customize**. Use the side panel to select only the databases you want to migrate to AlloyDB for PostgreSQL.
   6. Click **Continue**.
5. In the **Configure destination** section, do the following:
   1. From the **Destination instance type** menu, select **New cluster** .

      Database Migration Service uses the default AlloyDB for PostgreSQL configuration
      for a new cluster. Click **Customize** to adjust cluster features,
      such as the machine type, zonal availability, or data protection settings.
      For more information on cluster configuration, see
      [Create a cluster and its primary instance](https://docs.cloud.google.com/alloydb/docs/cluster-create.md.txt).
   2. In the **Password** field, enter a password for the default `postgresql` admin user. Database Migration Service connects as this user to migrate your data.
6. Click **Start migration** .

   Database Migration Service creates the migration job and begins the migration
   process. You can monitor the migration progress, as well as your
   destination cluster health in AlloyDB for PostgreSQL. For more information, see
   [View cluster information](https://docs.cloud.google.com/alloydb/docs/cluster-view.md.txt).

### gcloud

To use the gcloud CLI to migrate to a new AlloyDB for PostgreSQL cluster, perform the following steps:

1. **Create the network attachment resource.**   

   Create the network attachment in the project and Virtual Private Cloud network where your source database is located:

   ```bash
   gcloud compute network-attachments create NETWORK_ATTACHMENT \
     --region=REGION \
     --connection-preference=ACCEPT_MANUAL \
     --producer-accept-list=DEST_PROJECT_ID \
     --subnets=default \
     --project=SOURCE_PROJECT_ID
   ```

   Replace the following:
   - `NETWORK_ATTACHMENT`: The name of the network attachment to create.
   - `REGION`: The region for the network attachment.
   - `DEST_PROJECT_ID`: The project ID of your destination project.
   - `SOURCE_PROJECT_ID`: The project ID where the source network resides.
2. **Allow the Database Migration Service tenant project to access the network attachment.**   

   Retrieve the tenant project ID by running a validation check, then update the network attachment accept list to include it:

   1. Perform a validation check to retrieve the tenant project ID:

      ```bash
      gcloud database-migration private-connections create PRIVATE_CONN \
        --region=REGION \
        --network-attachment=NETWORK_ATTACHMENT_URI \
        --display-name=PRIVATE_CONN \
        --format="value(metadata.metadata.tenant_project_id)" \
        --validate-only
      ```

      Replace the following:
      - `PRIVATE_CONN`: The name of the private connection resource.
      - `REGION`: The region for the private connection.
      - `NETWORK_ATTACHMENT_URI`: The URI of the network attachment created in the previous step. For example, `projects/SOURCE_PROJECT_ID/regions/REGION/networkAttachments/NETWORK_ATTACHMENT`.
   2. Update the network attachment with the retrieved `DMS_TENANT_ID`:

      ```bash
      gcloud compute network-attachments update NETWORK_ATTACHMENT \
        --region=REGION \
        --producer-accept-list=DEST_PROJECT_ID,DMS_TENANT_ID \
        --project=SOURCE_PROJECT_ID
      ```

      Replace the following:
      - `NETWORK_ATTACHMENT`: The name of the network attachment.
      - `REGION`: The region.
      - `DEST_PROJECT_ID`: The project ID of your destination project.
      - `DMS_TENANT_ID`: The retrieved Database Migration Service tenant project ID.
      - `SOURCE_PROJECT_ID`: The project ID where the source network resides.
3. **Create the private connectivity configuration.**   

   Create the private connection in the destination project:

   ```bash
   gcloud database-migration private-connections create PRIVATE_CONN \
     --region=REGION \
     --network-attachment=NETWORK_ATTACHMENT_URI \
     --display-name=PRIVATE_CONN
   ```

   Replace the following:
   - `PRIVATE_CONN`: The name of the private connection resource.
   - `REGION`: The region for the private connection.
   - `NETWORK_ATTACHMENT_URI`: The URI of the network attachment.
4. **Create the source connection profile.**   

   Create the connection profile for the source PostgreSQL database:

   ```bash
   gcloud database-migration connection-profiles create postgresql SOURCE_CONN_ID \
     --region=REGION \
     --role=SOURCE \
     --host=SOURCE_PRIVATE_IP \
     --port=SOURCE_PORT \
     --username=SOURCE_USER \
     --password=SOURCE_PASSWORD \
     --private-connection=PRIVATE_CONN \
     --no-async
   ```

   Replace the following:
   - `SOURCE_CONN_ID`: The identifier of the source connection profile.
   - `REGION`: The region where you want to save the connection profile.
   - `SOURCE_PRIVATE_IP`: The private IP address of your source database.
   - `SOURCE_PORT`: The port of your source database (default is 5432).
   - `SOURCE_USER`: The username of the migration user on your source database.
   - `SOURCE_PASSWORD`: The password of the migration user on your source database.
   - `PRIVATE_CONN`: The name of the private connection resource.
5. **Create the destination AlloyDB for PostgreSQL cluster.**   

   Create the destination cluster and its primary instance. For detailed instructions, see the
   [Create a cluster and its primary instance](https://docs.cloud.google.com/alloydb/docs/cluster-create.md.txt) page.

6. **Create the destination connection profile.**   

   Create the destination connection profile pointing to the newly created AlloyDB for PostgreSQL cluster:

   ```bash
   gcloud database-migration connection-profiles create postgresql DEST_CONN_ID \
     --region=REGION \
     --alloydb-cluster=DEST_CLUSTER \
     --username=DEST_USER \
     --password=DEST_PASSWORD \
     --role=DESTINATION \
     --no-async
   ```

   Replace the following:
   - `DEST_CONN_ID`: The identifier of the destination connection profile.
   - `REGION`: The region where you want to save the connection profile. This region must be the same as your destination cluster region.
   - `DEST_CLUSTER`: The ID or full resource path of your destination AlloyDB for PostgreSQL cluster.
   - `DEST_USER`: The username of the migration user on your destination database.
   - `DEST_PASSWORD`: The password for the migration user in the destination database.
7. **Create the migration job.**   

   Create the continuous migration job with native replication enabled:

   ```bash
   gcloud database-migration migration-jobs create MIGRATION_JOB_ID \
     --region=REGION \
     --type=CONTINUOUS \
     --source=SOURCE_CONN_ID \
     --destination=DEST_CONN_ID \
     --use-postgres-native \
     --postgres-max-additional-subscriptions=10 \
     --databases-filter=DATABASES_LIST \
     --no-async
   ```

   Replace the following:
   - `MIGRATION_JOB_ID`: Your migration job identifier.
   - `REGION`: The region where you want to save the migration job.
   - `SOURCE_CONN_ID`: The source connection profile identifier.
   - `DEST_CONN_ID`: The destination connection profile identifier.
   - `DATABASES_LIST`: A comma-separated list of databases you want to migrate.
8. **Start the migration job.**   

   Start the migration job to begin the replication flow:

   ```bash
   gcloud database-migration migration-jobs start MIGRATION_JOB_ID \
     --region=REGION
   ```

   Replace the following:
   - `MIGRATION_JOB_ID`: The identifier of the migration job.
   - `REGION`: The region where the migration job is located.

### Quick-start migrations for existing clusters

To migrate databases to an existing AlloyDB for PostgreSQL cluster, follow these
steps:

### Console

1. Go to the **Clusters** page.


   [Go to Clusters](https://console.cloud.google.com/alloydb/clusters)
2. Select the AlloyDB for PostgreSQL cluster where you want to migrate your databases.
3. On the cluster details page, click **Migrate data**.
4. In the **Migrate data** panel, click **Migrate database** .

   The Database Migration Service quick-start migration form opens.
5. In the **Configure migration** section, do the following:
   1. From the **Destination region** menu, select the region of your destination AlloyDB for PostgreSQL cluster.
   2. In the **Migration prefix** box, enter a string that will be added to the names of all migration entities created for the quick-start migration: connection profiles, private connectivity configuration, network attachment and its subnet, and migration job.
   3. From the **Configuration type** menu, select one of the following:
      1. **Existing connectivity configuration**: Select this option if you already have a network attachment and a private connectivity configuration that uses Private Service Connect interfaces in the source database VPC network. This option is best used if you previously used quick-start migrations and want to re-use the same networking resources.
      2. **New connectivity configuration**: Select this option to create a new network attachment, network attachment subnet, and a private connectivity configuration in the source database VPC network.
6. In the **Connect source** section, do the following:
   1. Enter a **Hostname** or the private **IP address** of your source database. The source database address must be reachable from your source VPC network.
   2. Enter the **Port** that's used to access the host. The default PostgreSQL port is `5432`.
   3. Enter the username and password for the dedicated migration account in your source database.
   4. From the **Encryption type** menu, select one of the following:
      - **None**: If your source database doesn't require SSL/TLS-encrypted connections.
      - **Required**: If your source database requires SSL/TLS-encrypted connections. This option doesn't require any certificate verification.
   5. In the **Databases to migrate** menu, click **Customize**. Use the side panel to select only the databases you want to migrate to AlloyDB for PostgreSQL.
7. Click **Start migration** .

   Database Migration Service creates the migration job and begins the migration
   process. You can monitor the migration progress, as well as your
   destination cluster health in AlloyDB for PostgreSQL. For more information, see
   [View cluster information](https://docs.cloud.google.com/alloydb/docs/cluster-view.md.txt).

### gcloud

To use the gcloud CLI to migrate to an existing AlloyDB for PostgreSQL cluster, perform the following steps:

1. **Create the network attachment resource.**   

   Create the network attachment in the project and VPC network where your source database is located:

   ```bash
   gcloud compute network-attachments create NETWORK_ATTACHMENT \
     --region=REGION \
     --connection-preference=ACCEPT_MANUAL \
     --producer-accept-list=DEST_PROJECT_ID \
     --subnets=default \
     --project=SOURCE_PROJECT_ID
   ```

   Replace the following:
   - `NETWORK_ATTACHMENT`: The name of the network attachment to create.
   - `REGION`: The region for the network attachment.
   - `DEST_PROJECT_ID`: The project ID of your destination project.
   - `SOURCE_PROJECT_ID`: The project ID where the source network resides.
2. **Allow the Database Migration Service tenant project to access the network attachment.**   

   Retrieve the tenant project ID by running a validation check, then update the network attachment accept list to include it:

   1. Perform a validation check to retrieve the tenant project ID:

      ```bash
      gcloud database-migration private-connections create PRIVATE_CONN \
        --region=REGION \
        --network-attachment=NETWORK_ATTACHMENT_URI \
        --display-name=PRIVATE_CONN \
        --format="value(metadata.metadata.tenant_project_id)" \
        --validate-only
      ```

      Replace the following:
      - `PRIVATE_CONN`: The name of the private connection resource.
      - `REGION`: The region for the private connection.
      - `NETWORK_ATTACHMENT_URI`: The URI of the network attachment created in the previous step. For example, `projects/SOURCE_PROJECT_ID/regions/REGION/networkAttachments/NETWORK_ATTACHMENT`.
   2. Update the network attachment with the retrieved `DMS_TENANT_ID`:

      ```bash
      gcloud compute network-attachments update NETWORK_ATTACHMENT \
        --region=REGION \
        --producer-accept-list=DEST_PROJECT_ID,DMS_TENANT_ID \
        --project=SOURCE_PROJECT_ID
      ```

      Replace the following:
      - `NETWORK_ATTACHMENT`: The name of the network attachment.
      - `REGION`: The region.
      - `DEST_PROJECT_ID`: The project ID of your destination project.
      - `DMS_TENANT_ID`: The retrieved Database Migration Service tenant project ID.
      - `SOURCE_PROJECT_ID`: The project ID where the source network resides.
3. **Create the private connectivity configuration.**   

   Create the private connection in the destination project:

   ```bash
   gcloud database-migration private-connections create PRIVATE_CONN \
     --region=REGION \
     --network-attachment=NETWORK_ATTACHMENT_URI \
     --display-name=PRIVATE_CONN
   ```

   Replace the following:
   - `PRIVATE_CONN`: The name of the private connection resource.
   - `REGION`: The region for the private connection.
   - `NETWORK_ATTACHMENT_URI`: The URI of the network attachment.
4. **Create the source connection profile.**   

   Create the connection profile for the source PostgreSQL database:

   ```bash
   gcloud database-migration connection-profiles create postgresql SOURCE_CONN_ID \
     --region=REGION \
     --role=SOURCE \
     --host=SOURCE_PRIVATE_IP \
     --port=SOURCE_PORT \
     --username=SOURCE_USER \
     --password=SOURCE_PASSWORD \
     --private-connection=PRIVATE_CONN \
     --no-async
   ```

   Replace the following:
   - `SOURCE_CONN_ID`: The identifier of the source connection profile.
   - `REGION`: The region where you want to save the connection profile.
   - `SOURCE_PRIVATE_IP`: The private IP address of your source database.
   - `SOURCE_PORT`: The port of your source database (default is 5432).
   - `SOURCE_USER`: The username of the migration user on your source database.
   - `SOURCE_PASSWORD`: The password of the migration user on your source database.
   - `PRIVATE_CONN`: The name of the private connection resource.
5. **Create the destination connection profile.**   

   Create the destination connection profile pointing to the pre-created destination AlloyDB for PostgreSQL cluster:

   ```bash
   gcloud database-migration connection-profiles create postgresql DEST_CONN_ID \
     --region=REGION \
     --alloydb-cluster=DEST_CLUSTER \
     --username=DEST_USER \
     --password=DEST_PASSWORD \
     --role=DESTINATION \
     --no-async
   ```

   Replace the following:
   - `DEST_CONN_ID`: The identifier of the destination connection profile.
   - `REGION`: The region where you want to save the connection profile. This region must be the same as your destination cluster region.
   - `DEST_CLUSTER`: The ID or full resource path of your destination AlloyDB for PostgreSQL cluster.
   - `DEST_USER`: The username of the migration user on your destination database.
   - `DEST_PASSWORD`: The password for the migration user in the destination database.
6. **Create the migration job.**   

   Create the continuous migration job with native replication enabled:

   ```bash
   gcloud database-migration migration-jobs create MIGRATION_JOB_ID \
     --region=REGION \
     --type=CONTINUOUS \
     --source=SOURCE_CONN_ID \
     --destination=DEST_CONN_ID \
     --use-postgres-native \
     --postgres-max-additional-subscriptions=10 \
     --databases-filter=DATABASES_LIST \
     --no-async
   ```

   Replace the following:
   - `MIGRATION_JOB_ID`: Your migration job identifier.
   - `REGION`: The region where you want to save the migration job.
   - `SOURCE_CONN_ID`: The source connection profile identifier.
   - `DEST_CONN_ID`: The destination connection profile identifier.
   - `DATABASES_LIST`: A comma-separated list of databases you want to migrate.
7. **Start the migration job.**   

   Start the migration job to begin the replication flow:

   ```bash
   gcloud database-migration migration-jobs start MIGRATION_JOB_ID \
     --region=REGION
   ```

   Replace the following:
   - `MIGRATION_JOB_ID`: The identifier of the migration job.
   - `REGION`: The region where the migration job is located.

## Finalize the migration

When you decide to switch your application to the new AlloyDB for PostgreSQL
instance, finalize the migration by following these steps:

1. Stop all write operations on your source database. You can switch them to read-only mode to retain operational functionality.
2. [Promote the migration job](https://docs.cloud.google.com/database-migration/docs/postgresql-to-alloydb/promote-migration.md.txt).
3. Optional: [Verify migration data](https://docs.cloud.google.com/database-migration/docs/postgresql-to-alloydb/verify-migration.md.txt) for completeness.

## What's next

- [Learn about other migration flows and full Database Migration Service capabilities](https://docs.cloud.google.com/database-migration/docs/overview.md.txt).