How do I make a replica recieve only a subset of documents from a master? What i would like to do is create a master database for several divisions then replicate only the documents they need to smaller databases (on same server as the master) then replicate those databases to the separate devision servers. Thank you for any help you can give me!
Subject: Filter using replication
You canot replicate the master to smaller databases on the same server. You can replicate the master to subsets on the other servers without a problem.
Look at this document to start with in the help. This is the online version
It is in the client help index under:
Replicas
Selective
Hope this helps
Subject: Filter using replication problem
I have master database of enterprise (master database) and it’s subsets (company databases). I create a filter using replication formula. Replication fromula for company database looks like this:
SELECT CompanyId=
I have operation of move some documents from one company database to another. This operation I perfom by changing value of CompanyId field. And when running of this process concur with replication process on server some documents are disappear from all replicas. When this process runs with checked Temporary disable replication setting documents are not disappear.
Have you any suggestion ?
Thanks.
Subject: All works fine ! It was my bug