Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arbarnhart
Starting Member
1 Post |
 Posted - 2004-10-13 : 11:31:46
|
| We are considering using SQL Server 2005 for development of a product, with Express as the solution for some installations where SQL Server isn't licensed. We had started down the SQL/MSDE 2000 route first. One of the things we are doing is merge replication. This looks to be a problem. In 2000, it wasn't:<<< MSDE 2000 can act as both a Publisher or Distributor, and a Subscriber, and it can replicate between MSDE versions and regular versions of SQL Server. Additionally, you cannot use it for transactional publication, but you can use it as a Publisher of snapshot replication, and merge replication, and as a Subscriber to all three types of publications. >>>Compare this with the info on Express:<<< SQL Server Express supports subscription to merge, snapshot, and transactional publications, but does not permit publications itself. >>>If I read this correctly (and it seems to be a pretty blunt statement), then publication of merge replicas is not permitted in Express. I had assumed Express was to be back compatible with MSDE. Perhaps not. Is there going to be an MSDE product also or is MS just pulling the run out from under us? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-10-13 : 13:00:58
|
| yes, some limitations of MSDE were removed and some were added in the SQL Express product. this happens to be an added limitation.Atleast the query governor is gone.-ec |
 |
|
|
|
|
|
|
|
replication