Versions Compared

Old Version 2

changes.mady.by.user Olga Vorobyova

Saved on

compared with

New Version Current

changes.mady.by.user Olga Vorobyova

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Term

Description

Publication

Server(database)that sends data to another server(database)

Distribution

Server that controls data flow via replication system. Contains a specialized distributor database. Distribution and Publication can coincide.

Subscription

Server(database)that receives data from the other server(database)

Publication

Sum of articles, sent to Subscription

Article

Main replication module: table or table's subset

Subscription

Data group, received by Subscription

Distribution database

System database that is saved at Distribution and doesn't contain user tables. Is used for saving the task snapshots and all the transactions, waiting for distribution by the Subscription

 

 

 

Info
titleNote.

On default Replication service is not installed together with MS SQL Server Express.

 

 

 

Info
titleNote.

MS SQL Server Express cannot be used as Publication or Distribution.

 In the Auto-Intellect distributed architecture it is reasonable to use replication with topology «Central subscription». In this case several Publication servers (for example servers, installed on traffic control posts) copy the data to the central server– Subscription.

...