none
What is the difference between distributed and replicated database?

Answers

  • Brandon has answered the question what is the difference between a distribution database and a replicated database.

    I am going to answer the question what is the difference between a distributed database and a replicated database.

    A replicated database is a destination database which a source database copies all or part of its objects and data to. This can be a one time copy, or a continuous copy, and in some cases the destination database can copy changes back to the source copy.

    A distributed database is a database which is shared over more than one physical machine. The underlying technology used by a distributed database may involve replication or duplication. Consult this article for more information on it:

     http://en.wikipedia.org/wiki/Distributed_database


    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Monday, August 01, 2011 1:18 PM
  • The distribution database stores metadata and history, as well as transactions for transactional replication.

    Configuring Distribution

    The replicated database is the publication and/or subscription database.


    Hope this helps.
    www.sqlrepl.com

    • Proposed as answer by Kasturi Rajesh Monday, August 01, 2011 6:57 AM
    • Marked as answer by Stephanie Lv Friday, August 05, 2011 10:45 AM
    Saturday, July 30, 2011 1:56 AM

All replies

  • The distribution database stores metadata and history, as well as transactions for transactional replication.

    Configuring Distribution

    The replicated database is the publication and/or subscription database.


    Hope this helps.
    www.sqlrepl.com

    • Proposed as answer by Kasturi Rajesh Monday, August 01, 2011 6:57 AM
    • Marked as answer by Stephanie Lv Friday, August 05, 2011 10:45 AM
    Saturday, July 30, 2011 1:56 AM
  • Brandon has answered the question what is the difference between a distribution database and a replicated database.

    I am going to answer the question what is the difference between a distributed database and a replicated database.

    A replicated database is a destination database which a source database copies all or part of its objects and data to. This can be a one time copy, or a continuous copy, and in some cases the destination database can copy changes back to the source copy.

    A distributed database is a database which is shared over more than one physical machine. The underlying technology used by a distributed database may involve replication or duplication. Consult this article for more information on it:

     http://en.wikipedia.org/wiki/Distributed_database


    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Monday, August 01, 2011 1:18 PM
  • Hi,

    In simple terms, distributed database is one which has primarily role of distributing the publications from publishers to subscribers.So what it holds inside it the information about  who are publishers, subcribers and which subscriber has subcribed to which publications and about which publications have successfully reached the subcribers and which are pending to be published. There can be only one distribution database for mutliple subscriptions.

    Replicated database, in simple terms are the publisher/ subcribers databases which receives the publication and get replicated to publisher/subscriber.

    Regards,


    Regards, Vishal Srivastava
    Tuesday, August 02, 2011 9:55 AM