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 |
|
gaupa@zcon.net
Starting Member
2 Posts |
 Posted - 2006-07-07 : 08:17:39
|
| Hello Everybody, If any one have solution then please help me. Thanks in Advance. I do the following steps:I have created two publications on my SQL SERVER for merge replicationPublication A – which returns all rows from the Table1Publication B – which returns all rows from the Table1 where the field MANAGER =’ABC’ I have two clients who have MSDEClient 1 is subscribed to Publication A and Client 2 is subscribed to Publication B All works fine till now and I am able to make transfers from the two clients and get all the changed data However, now If I change the filter rules for Publication B and set that it should return all rows from the Table1 where the field MANAGER = ‘DEF’ , SQL Server tells me that I have to reinitialize all snapshots for all subscriptions. If I don’t do this it doesn’t allow me to make a transfer from my Client 1.As you can see in my example I have not made any changes to Publication A to which Client 1 is subscribed. So this seems to be illogical. In our case it would not be possible for us to reinitialize the subscriptions for all Publications when the rules for only one Publication are changed because we may have a lot of clients connected to our Server and if we reinitialize the subscription then all the data is sent again. If anybody know that how to restrict the other publications then please tell me how we can do. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-07-12 : 09:03:27
|
| When you re-initialise the snapshots, it will only push changes that have been made to the publication since the last snapshot, so the only change will be the filter. The problem with creating a published article in more than one publication is that any changes will have to be propogated to all subscribers on any publication with that article.. |
 |
|
|
|
|
|
Problem in Multiple Publication on Single Table