Replicate views from Postgres to Postgres on AWS DMS

Question

I'm using AWS DMS to migrate data from one Postgres database to another Postgres database. Everything works fine, except one thing: the views are no replicated on my target database.

I've read that this cannot be done between heterogenous database (i.e. from Oracle to Postgres) using DMS, but I imagine that this is possible somehow when we're using the same database.

Does someone know how to replicate the views using AWS DMS from Postgres to Postgres?

Answer 1

DMS is a data migration service. View is a virtual table(represented by sql code/object) and it does not contain any data by itself like a table does.