sql server replication: Possible to Filter publication per device on SQL 2005? -- sql server replication

Possible to Filter publication per device on SQL 2005?

Roby2222
9/14/2006 3:08:02 PM

sql server replication:

Is there any new functionality in SQL 2005 that allows you to deliver a
different subset of data per client by supplying a parameter to filter by?

Example: I have a product_warehouse table that contains all products for all
warehouses. I want to replicate this data onto PDAs with SQL Mobile 2005,
however I only want the PDA to receive the data for 1 specific warehouse, not
all warehouses. On a second PDA, I want to pull the data for a differnet
warehouse.

I realize this can be accomplished by using horizontal filtering and
creating a publication for each warehouse, but there are about 100 of them,
so this just isn't practical.

Any ideas if this is possible?

Thanks,

Re: Possible to Filter publication per device on SQL 2005?

Hilary Cotter
9/14/2006 8:17:01 PM

Filter by hostname or publisherlogin. These map to Host_name() or
suser_name()

--
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

[quoted text, click to view]