Two kinds of servers take part in the replication:

  1. Server, publishing the data, i.e. where the data are added and transferred to the central database;
  2. Server, storing data from all the publishing servers to a single central database.

Publishing servers should operate under control of the «SQL Server 2008»full version.

SQL Server Express program doesn't permit data publishing.


Setting up the replication for recognition database is done in a similar way.