I am replacing a custom sychronisation system with merge replication.
The current system on the server side allows you to select what data a client can sync to their device and edit, i.e. they will likely have a subset of the tables available, not all of them.
I was wondering if you can do that with merge replication? We don't want a separate publication for each client as we will have a large number of clients, but is there a way when setting up a subscription to exclude certain tables that are being published?
I guess the end goal is that our databases are very large and we want to reduce the data being sent to the clients, especially if it is data that they won't be needing.