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 |
|
buraktuf
Starting Member
13 Posts |
 Posted - 2009-02-09 : 02:22:38
|
| Hi everyone,I've got a problem with a replication system. In my database i have a table which should be publicated according to two different publication procedures. for example, my tables name is 'Customer' which includes 'CenterIsActive' and 'CustomerIsActive'. These id columns can just take the values 1 or 0. And at my subcription site, this table is publicated to a table named 'CustomerS'. I want to publicate 'Customer' table with a filter so, When the CenterIsActive value is 1 then this partition of the 'Customer' table according to the filter(select * from Customer where CenterIsActive=1) should be "Download only,prohibit changes at Subscriptor" in merge replication. And again in an another publication for the same table according to another filter(select * from Customer where CustomerIsActive=1) the putcoming partition of the 'Customer' table should be "Bidirectional". But when i created two publications assume P1 and P2, when i select the table in P1 and wrote the filter and select the Download only option,then in P2 again select the table and also wrote the appropriate filter and select the Bidirectional option, it changes also the options of the P1 as Bidirectional. how can i solve this issue? please help me and thanks a lot for any reply.. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-09 : 17:13:42
|
| http://www.replicationanswers.com/MergeChangesArticle1.asp |
 |
|
|
|
|
|
Two seperate publication contain one table