May 22, 2009 at 5:01 am
Hi All,
My req. is that I need to sync my test environment with the prod data for which I have set Transaction replication with pull subscription. The issue is my tester does add/modify some data in the tables and these changes are reflected in the PROD Server.
How Should I configure my subscription so that any changes in it will not propagate to PROD server.
Help greatly appreciated.
"More Green More Oxygen !! Plant a tree today"
May 22, 2009 at 1:21 pm
Hi,
Apparently you set up an updatable transactional replication. You should rebuild the replication, stating that it cannot be updated. Until that, remove the write permission of the developers 🙂
-- Erik http://blog.rollback.hu
May 22, 2009 at 10:34 pm
Thanks for reply.
I think updatable subscribtion will propagate updates to the publisher which I dont want. My req. is publisher should updates the subscribtion so that the data are in sync with publisher server but users can read/write the subscription database without the subscribtion data updating the publisher.
Minaz
"More Green More Oxygen !! Plant a tree today"
May 23, 2009 at 4:53 am
Bingo !!:-D
I resetup the Transaction Replication with readonly subscribtion and the local users are able to update & insert the data to the subscribtion Database but the changes are not propagated to the publisher.
"More Green More Oxygen !! Plant a tree today"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply