SQL Server Performance

Two-Way Replication

Discussion in 'Performance Tuning for SQL Server Replication' started by vg15, Sep 19, 2006.

  1. vg15 New Member

    Problem

    Currently: Web Servers and Internal Users point to the same database.

    Web site needs to run as fast as humanly possible, read/write access to the database.

    Internal users import data that will need to make its way over to the database the website uses.

    Could it be setup that changes to the website db get replicated over to the other database every 5 minutes or 15 minutes, and changes on the internal database get replicated over to the web database every x hours?

    Would this be possible SQL 2000 or SQL 2005.
  2. dineshasanka Moderator

    I think you can do this from transactional replication of SQL Server 2000

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

  3. ghemant Moderator

    Hi,
    if the data of the internal database and webservers are need to get replicated in each other then Merge Replication would be usefull.

    Regards

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
    ------------------------
    http://hemantgirisgoswami.blogspot.com
  4. dineshasanka Moderator

    can merger replicated subscribe act as a another publisher to another db?


    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

  5. ghemant Moderator

    Hi,
    i wrote this because i read an article by Alexander Chigrik on
    http://www.mssqlcity.com/Articles/Replic/SetupMR/SetupMR.htm , here it shows a method of PUBLISHING SUBSCRIBER. Plz i am not offending you but its my humble try give a link for the same.

    Hope you won't mind.

    Regards

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
    ------------------------
    http://hemantgirisgoswami.blogspot.com

Share This Page