December 4, 2003 at 12:25 pm
I would like to have one publication (sales data), and have several subscriptions.
Each subscription only getting "Their" data (i.e. sales branch).
Any suggestions on how to do this?
December 4, 2003 at 5:21 pm
Transactional doesnt give you much help with this. Merge does it fairly well, lets you use joins to qualify what data goes where, often based on hostname.
Andy
December 5, 2003 at 5:40 am
I am using MERGE.
Any hints on what I might be able to use besides hostname? Hostname might work, but I would like to find out what my options are.
Thanks!
December 6, 2003 at 6:52 am
Search for "Dynamic Filters" in BOL. A subset of that text:
"In the dynamic filter, you specify a Microsoft® SQL Server™ 2000 function or a user-defined function that is evaluated differently for each Subscriber based on the connection properties of the Merge Agent when the merge process is replicating data between the Subscriber and Publisher. The most common system functions used for this purpose are SUSER_SNAME() and HOST_NAME(). You can use a user-defined function in a dynamic filter, but unless the user-defined function definition includes SUSER_SNAME(), HOST_NAME(), or the user-defined function evaluates one of these system functions in the filter criteria (such as MyUDF(SUSER_SNAME()), the user-defined function will be static."
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply