Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
In This Section
Title | Description |
---|---|
Describes the different replication components and replication types. |
|
Compares the replication features available with SQL Server Express and MSDE. Lists the SQL Server Express client and server replication scenarios. |
|
Describes the replication considerations for SQL Server Express. |