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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-19 : 07:47:59
|
| Simon writes "I’ve have provided from a centralized database (set as the main db with publisher and distributor) merge replication with push subscribers by Sql Server 2000. Publisher and subscribers databases have homogeneity structure and stored hospital info. The main hospital center (publisher) db stores the full information about all patients from all hospitals. Every subscriber keeps specific information for a fixed hospital which is a subset from the center db info and I must transfer only it to the subscriber from the center db by any criteria – the classical example to be used replication filters. I tested filters as queries and they return the right results. But when I synchronized - replication transfer not returns to subscribers all needed rows and even nothing for 2 tables. I’ve tried to synchronize only one subscriber with the publisher, but again the same result.Try to help me, please. Thanks in advance.Simon." |
|
|
|
|
|
merge replication filtering problem