Click to Rate and Give Feedback
MSDN
MSDN Library
Collapse All/Expand All Collapse All
Other versions are also available for the following:
SQL Server 2008 Books Online (February 2008)
Feature Comparison Between MSDE and SQL Server Express
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

The following table compares the replication features of MSDE and Microsoft SQL Server 2008 Express Edition (SQL Server Express).

Feature SQL Server Express MSDE

Snapshot Publications

No

Yes

Transactional Publications

No

No

Merge Publications

No

Yes

Snapshot Subscriptions

Yes

Yes

Transactional Subscriptions

Yes

Yes

Merge Subscriptions

Yes

Yes

Note:
Either SQL Server 2000, SQL Server 2005 or SQL Server 2008 can be the Publisher for SQL Server Express and MSDE. The Publisher is a database instance that makes data available to other locations through replication.

© 2010 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker