-
replication with sql server CE in mobile device
hello there,
currently i'm developing a mobile apps(pocketpc) with DB interaction either locally(sql server CE) or externally(sql server 2000). i intend to use sql server replication(merge replication) to synchronise both of them.
but my application is meant for multiple users. thus, i won't replicate data which is not belong to the user.
i found no other way to do this except by implementing dynamic filter(ex: SUSER_NAME).as a result, i'm having problem to access the publication with a new DB user but it was a success if i access using 'sa'.
can anybody help me ???
hopefully my words are understandable
kindly help
regards
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|