Row filter vs join filter

Discussion in 'microsoft.public.sqlserver.replication' started by HKM, Sep 9, 2004.

  1. HKM

    HKM Guest

    Hi,

    I am new to replication, I am confusing with row filter and join filter. If
    I only use row filter, does the SQL server replication caused any data
    integrity problem? e.g. simple relationship of such table tblCustomer,
    tblOrder and tblOrderDetail?

    Thank you.

    HKM
     
    HKM, Sep 9, 2004
    #1
    1. Advertisements

  2. HKM

    Paul Ibison Guest

    HKM,
    usually you would combine the two, if the tables are
    related and are in the same publication. It is possible
    for this not to not cause an error if you use NOT FOR
    REPLICATION clause on the FKs otherwise.
    HTH,
    Paul Ibison

    (recommended sql server 2000 replication book:
    http://www.nwsu.com/0974973602p.html)
     
    Paul Ibison, Sep 9, 2004
    #2
    1. Advertisements

  3. a row filter normally means you filter by a column on a row with a value.

    Ie in the authors table a row filter would look like this

    where state='ca'

    When you do a join filter you are joining on another table for your
    filtering criteria.
     
    Hilary Cotter, Sep 9, 2004
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.