Wednesday, March 21, 2012

Merge replication problem

I create a merge publication of a database I have on sql server 2005.
The target platform for this database is a pocket pc. Everything
works great, until I dig under the covers a little. Lets say I have a
table a, and that table is filter to only show a subset of its
records. When I look at the database/table in VS2005 I see exactly
what I expect. However, when I deploy it to a pocket pc and then look
using query analyzer on the pocket pc I see all the records that are
in the original table not just those that I filtered out. What is
happening?
It is possible that your filtering criteria is not being resolved correctly
in your pocket pc. What is your filtering criteria?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"BetaD" <dhorth@.horth.com> wrote in message
news:1173818653.274797.32580@.b75g2000hsg.googlegro ups.com...
>I create a merge publication of a database I have on sql server 2005.
> The target platform for this database is a pocket pc. Everything
> works great, until I dig under the covers a little. Lets say I have a
> table a, and that table is filter to only show a subset of its
> records. When I look at the database/table in VS2005 I see exactly
> what I expect. However, when I deploy it to a pocket pc and then look
> using query analyzer on the pocket pc I see all the records that are
> in the original table not just those that I filtered out. What is
> happening?
>

No comments:

Post a Comment