Export (0) Print
Expand All
6 out of 16 rated this helpful - Rate this topic

Replication in SQL Server Express

SQL Server 2005

Replication is the process of sharing data between databases in different locations. Microsoft SQL Server 2005 Express Edition (SQL Server Express) uses a publishing industry model to represent the processes in replication architecture. These include Publisher, Distributor, Subscribers, publications, articles, and subscriptions.

Replication for SQL Server Express originates with a publication created in SQL Server 2005. The computer that is running SQL Server 2005 is the Publisher. The computer that is running SQL Server Express can be a Subscriber and receive data from that SQL Server database. SQL Server Express functions only as a Subscriber.

Title Description

Basics of Replication

Describes the different replication components and replication types.

Feature Comparison Between MSDE and SQL Server Express

Compares the replication features available with SQL Server Express and MSDE. Lists the SQL Server Express client and server replication scenarios.

Replication Considerations (SQL Server Express)

Describes the replication considerations for SQL Server Express.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.