• Depends on the various business requirement replication can be set up between Publisher and subscriber. It can also support heterogeneous environment.

    Refer following BOL topic for further detail and understanding. It also contains detail explation with sceniro.

    http://technet.microsoft.com/en-us/library/ms152531(v=sql.105).aspx

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."