Transactional Replication With Updatable Subscriptions

[pbaylis1]

Say the subscriber table has more columns than the publishing table, can the replication simply update the matching fields and ignore the rest?

[masterkeshav]

@pbaylis1 1.) ONe way is to have views and replicate the actual table and the view but restrict users from reading data from the table. I.E. allow them only to read data from the replicated view.

2.)the way this is traditionally done is to grant your replication account rights to only update the columns you want to modify. your publisherlogin account could be an account called test. Ensure that this account has rights to update all columns but the one you do not wish to be update.

[pbaylis1]

Thank you. Very useful for my current project.