Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spart
Starting Member
5 Posts |
 Posted - 2007-12-03 : 06:22:59
|
| I have a database which i have replicated using merge replication,how can i enable only the publisher to replicate(download) the data to the subscribers and block any data changes that occur at the subscriber from replcating back to the publisher? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-03 : 06:24:09
|
| Change your replication to Transactional replication, this does the job for you. |
 |
|
|
spart
Starting Member
5 Posts |
Posted - 2007-12-03 : 09:57:10
|
| When i change my replication to Transactional replication which options should i choose in the articles properties window so that the replication is only one way from the(Publisher) |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-03 : 10:52:36
|
| Transactional is only one way as long as you do not choose updateable. |
|
|
|
spart
Starting Member
5 Posts |
Posted - 2007-12-04 : 04:25:31
|
| By the way how comes i can't use Merge Replication for a one way replication? the options in the articles properties window like "Download only to suscriber,allow subscriber changes" do not work because any chages i make on the subscriber database are still replicated on the publisher |
|
|
|
|
|
|
Merge Replication