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 |
|
OLOPS
Starting Member
1 Post |
 Posted - 2007-11-28 : 22:45:03
|
| I have a central server (CS1) with database CDB and a branch server (BR1)Inside the branch server, there are two database DB1 and DB2.CDB contains data for DB1 and DB2I made a subscription in the brancserver named BR1:DB1(this will replicate the data from CDB to DB1)I also made a subscription for DB2 named BR1:DB2(this will replicate the data from CDB to DB2)Unfortunately, upon starting the synchronization for BR1:DB1, the data replicated into DB1 also contains data for DB2. same happens with the BR1:DB2..How do I filter the data that will be replicate per database..Example:only data for DB1 coming from CDB should be replicated into DB1 if that specific subscription(BR1:DB1) is synchronized.Thank you |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-29 : 01:41:30
|
| Create separate publications for each subscriber. |
 |
|
|
|
|
|
Replication multiple subscriber database