If you want to bring the data over from a table that doesn’t have a primary key, you have a few options:

1. You’ll have to add a primary key prior to starting the migration.
2. You’ll need to bring the data over yourself after the initial migration. Keeping in mind of course that if you bring the data over yourself, even if you maintain the connection, DMS won’t replicate data for that table moving forward.
3. You can export the table from the source instance and import it into the new instance.
4. Finally, you can create a table with the same schema as the one you have that doesn’t have the primary key, give it a primary key (should use a sequence generator to autogenerate the key) and copy the source data into it. Then do the migration.

#postgresql #migration #database migration service