SQL Server Performance

trans. rep. - sql2k

Discussion in 'General DBA Questions' started by bfarr23, May 30, 2005.

  1. bfarr23 New Member

    I have 220,000 records in a published database.
    this data originated from 120 different sources. (FTP --> DB)

    each of these sources want to specify exactly when their published data is sent to the subscribers.

    i have one publisher and 4 subscribers.

    is this possible?

    the records are marked with an "uploadedby" field.
  2. SQL2000DBA New Member

    Hello,

    My understanding is that you have one publisher and 4 subscriber and You want to publish data to subscriber only when your publisher data gets updated. If my understanding is correct then you can set transaction replication where in log reader will monitor log file for any insert,update and delete. Based on updation, you can published the data to 4 subscriber and it is workable in SQL server.

    Please read this in books online.
    transactional replication, cleaning up



    Thanks and regards
    Ravi Kumar

Share This Page