SQL Server Performance

Snapshot replication

Discussion in 'Performance Tuning for SQL Server Replication' started by vpandey, Sep 15, 2003.

  1. vpandey New Member

    I want to replicate some data from one database to other database. The data to be replicated need to be filtered based on various conditions involving many tables Example

    select * from a,b,c where a.x=b.x and b.x=c.x and a.y='vivek'

    So I need to specify joins. Further I have to replicate many tables based on various conditions. How to do it. Is there any way to specify a DTS package while configuring publisher? I can have all the conditions in a DTS package and specify the same in while configuring publisher.
    Server version MS SQL 2000
    Or can you suggest me an alternative method.
    Other relevant information
    Replication to be done at the end of the day
    Users at remote database should be able to perform operations on the database.
    Regards
    Vivek
  2. Twan New Member


    I think that you'd have to:
    create a table in the source database
    populate it with the data you want each night
    replicate this source table on a nightly basis

    I don't think that there is a way to replicate a join or the data within a view...

    another option might be to replicate the three tables and a view definition...

    Cheers
    Twan

Share This Page