Post reply

Dynamic Filter & Dynamic Snapshot Replication ?

  • July 18, 2003 at 6:11 pm

    #80813

    Enviroment: Merge Replication, with MSDE Anonymous Pull Subscribers at numberous branch offices with one publisher/distributor at the central office.

    Each Subsbriber is within a branch, and each branch has their on branchID field in the database.

    All the published Tables have a BranchID field, and I have a seperate table that associates an SQL Login Account to a BranchID.

    I am trying to implement a replication where the branch will only download related records for its own branch.

    I have setup the dynamic filter, but I did not setup dynamic snapshot.

    eg: of my filter:

    SELECT <published_columns> FROM clients

    WHERE BranchID= ( select BranchID from BranchUsers where username= suser_sname())

    When I create the initial snapshot the records are not exported.

    Any ideas, suggestions, & thoughts would be appreciated.

    thank you,

  • July 18, 2003 at 6:57 pm

    #466115

    Got it working now.

    thank you.

  • October 10, 2006 at 12:50 pm

    #665073

    How did you setup the dinamic snapshot  , how many suscriber do you have.

    i'm traing to do the same. But ussing the Sql server Winzards for all my 500 suscribers is a pain.

    Pedro R. Lopez
    http://madurosfritos.blogspot.com/[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply