May 17, 2011 at 11:36 am
Hi, we have created an Administration database that we have several lookup type tables that we would like to maintain in 1 database and replicate to 1 or more OLTP databases. I would like to ping the community for best practices for the replication type and security for this process. I would like to Grant READ-ONLY access to all users for the replicated lookup tables in the individual OLTP databases to make sure only the Admin database replication can change data or the schema.
Thanks in advance for your advice.
Scott
May 17, 2011 at 1:35 pm
As this is centrally updated you would want to go with either transactional or snapshot. You can eliminate snapshot if the data is need 100% of the time or you are talking about a lot of data.
Permissions can be assigned post set up.
Another point of consideration is if you have a need to access these tables from multiple databases in the same instance it would be worth having a single database being reference logically by views to minimise the load on the distributor.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply