Feature Comparison Between MSDE and SQL Server Express
The following table compares the replication features of MSDE and Microsoft SQL Server 2005 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 or SQL Server 2005 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. For more information about replication, see Basics of Replication.
See Also
Concepts
Replication Considerations (SQL Server Express)
Other Resources
Replication in SQL Server Express