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.

All Forums  SQL Server 2005 Forums  Replication (2005)  P2P replication filtering/partitioning by user

Author  Topic  laurene Starting Member 1 Post Posted - 2009-10-23 : 12:00:24 Hi, I am using SQL Server 2005 P2P replication in a 2 Domain system (connected by a one-way diode). We replicate everything around DomainA and use our own code to forward relevant data from DomainA to DomainB but, once in DomainB, we do not want the forwarded data to be replicated as we have very low bandwidth available to us. We do, however, want data created in DomainB to be replicated. We also have a schema design which uses inheritance with common attributes being held in base tables. I could solve this by setting flags on the forwarded data in the base tables and filtering DomainB's replication to exclude flagged rows but this feels like a messy solution that requires us to add columns onto tables that have nothing to do with the data itself purely for our own management purposes. So, what I am wondering is, is it possible to prevent data changes made by one user/process from being replicated within a domain whilst still replicating changes made by any other user/process? Thanks for your help, Lauren