We have a production database which now we want to replicate into another DDBB (SQL Server). After some research we have found that transactional replication may be the best solution for our scheme. Since you need a PK for each table of your datamodel for transactional replication, we were guessing if its a good a idea/practise to add PK to all tables that currently has NOT a PK (N-N tables).
I have done some small testing and EF does not complain about adding new fields into the DDBB. Performance I dont think will be an issue, but still I am wondering if there is a better or cleaner way of doing this.
What do you think? Would you add a PK to each table a big data model just for replication?
