Creating a migration

After you use the EDB DMS Reader to read the source database, create a new migration in the EDB Postgres® AI Console. This establishes a sync between the source database and a target cluster in the EDB Postgres AI Console.

1. Access the EDB Postgres AI Console and log in with your EDB Postgres AI Database Cloud Service credentials.

2. Select the project where you created the database cluster.

3. Within your project, select Migrate > Migrations.

4. In the Migrations page, select Create New Migration > To Managed Postgres.

5. In the Create Migration page, assign a Name to the migration.

6. Select the Source of the migration. The ID for the EDB DMS Reader is listed in the drop-down menu.

7. Under Destination, select a target cluster for the migration and enter the name of the database where you want the migration to copy data and select Next.

8. Select the tables and columns to migrate. Modify the table and column names if needed.

9. Select Create Migration.

The EDB Postgres AI Console now displays a new migration. The EDB DMS Reader is constantly streaming data when the migration displays the Running state. Changes to data are replicated from the source to the target database as long as the migration is running.