sql server replication: Subscription -- sql server replication

Subscription

GC
2/7/2006 6:04:28 AM

sql server replication:

Hi,

I create a Merge replication with Sql Server 2000 on a server Windows 2000
Server
I use a Remote Distributor also on Windows 2000 server.
All the salesman use a Laptop with Windows XP and MSDE database

I Create a pull subscription with all the articles I need

Now if I have 5 laptop for 5 salesman that want to work disconnected to the
system,
Do i need to create one subscription for each salesman or if I can use
the same subscription for all the salesman.

I'am asking this because the articles for each saleman are the same

Thak you in advance!

Re: Subscription

Hilary Cotter
2/7/2006 9:52:33 AM

You could use a single publication. Each subscriber will have to create
their own subscription or you will have to create it for them. Note that
this will mean that each subscriber gets the same data, this might be ok,
but chances are that it is not and you may end up with conflicts.

You might want to look at dynamic snapshots and dynamic filtering to only
send each salesman the data they need and to minimize conflicts.

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