Note: A backend developer here with little to no experience in setting up database servers and replication.
What needs to be done
Setup DB replication of an existing database with the following constraints:
- Replicate only a specific list of tables/views with different names in the replicated database.
- Change the name of the tables/views in the replicated database (during the replication process)
- Setup a user on the replicated DB with further restrictions with which only a set of table/view can be viewed/updated/deleted
Progress so far
I have already read the document here, however, I did not find anything concrete to help me move forward with all the use-cases I wish to support!
Show only essential data to the external vendor.
PS: If there are any other approaches other than replication, would be happy to consider and implement that as well.