Applying constraints

At the beginning of your data migration journey with EDB Data Migration Service (EDB DMS), you prepared and imported the schema of your source database. Now, connect to the target database and re-apply the constraints that were excluded from the schema and data migration.

Primary key and unique constraints

For primary key and unique constraints, you have already created the tables and constraints in the target Postgres database. This allowed EDB DMS to map them to the source objects and migrate data successfuly. You don't need do to anything else.

The same applies to not null constraints if you included them in your schema import.

Foreign key, check, and exclusion constraints

You can now re-apply any foreign key, check, or exclusion constraints you excluded during the schema preparation and import.

Ensuring data integrity

Rows in tables that don't have primary key or unique constraints were migrated with at-least-once delivery, therefore, it is possible that these rows are duplicate.

Deduplication can be performed as part of the verification.