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.
See Also
Concepts
Replication Considerations (SQL Server Express)