Newbie Merge replication question

Hot Topic

Union problem
I messed up (again) - install Error
weird and funny question
Replication without initialize subscriptor with the snapshot
How to delete rows in tables...
Ordering and rearrangement records.
two independent drill downs in matrix report
Get last record in a SQL database
Store Webservice Task Output to File
Newbie Question

SQL Server

WQL Query - Where Cluase
SSIS Expression result limit of 4000 bytes
How to launch them??
add additional right scale on chart report
Replication Timeout Issue
Comments in SQL
Programming SSIS - Exception 0xC0204006
Dynamic data source name...
SQL Server 2005 - Transactions
SQL Server developer edition failsinstall fails - sqlsui.rll could not be loaded

Newbie Merge replication question

Hi!

I'm setting up a merge replication for sql ce. Ten guys with windows mobile 5 pocket pc works as service technicians and need to synchronize data in the field.

The backend database is huge and I just want each person to have their own data on the pda and synchronized, they have unique userid's in the database. Is it possible to filter data for each person or do all have to have all data that's in the backend database

/Magnus




Answer this question

Newbie Merge replication question

  • JVJ

    Merge replication permits the agents to have subsets of the data based on how the Publication is programmed. One alternate approach would be to publish individual agent tables, but this gets messy as agents are added and removed.

  • Stefan Wrobel

    Could I use a "translator" table to translate suser_name()'s to applications userid's Then in the filter query against this table to identify the user One solution could be to have one Publication for each employee Yes it would become messy to administer. But my problem can't be unique. How do you all query out data for each employee

  • Anton__

    You could have each user identifying themselves when using the application, and setting their userid as HostName on your replication object. Then you can reference this in your publication filter with HOST_NAME().

  • Newbie Merge replication question
Answer this question