msde vs express edition & transactional publisher

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.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

msde vs express edition & transactional publisher

Author

Topic

ozgunnew
Starting Member

13 Posts

Posted - 2006-09-18 : 04:09:38

Hi;
In http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=71679 topic, it is stated that SQL-DMO can be used to make msde publisher for transactional replication.
But in http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=71983 topic, Rishi said that "No Express Edition cant act as Publisher".
I am not clear about the difference btw msde and express.
Why msde can be publisher for transactional replication by SQL-DMO and why express edition can not be?
Thank you so much...

Rishi Maini SQL2K5 Admin
Yak Posting Veteran

80 Posts

Posted - 2006-09-18 : 09:23:18

Its because in MSDE we used to have SQL Server Agent Service, through which you can create jobs for Replication agents but unfortunately in Express Edition we do not have SQL Agent at all, so there can be no jobs that can act as Replication Agents.

I am not sure as to why SQL Agent Service is removed from SQL Express Edition :-(

Thanks
Rishi Maini

Rishi Maini SQL2K5 Admin
Yak Posting Veteran

80 Posts

Posted - 2006-09-18 : 09:53:32

Please note I have just made a modification for http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=71679

The modification is that infact MSDE can't act as Publisher for Transactional but can for Merge and Snapshot.

But still your confusion earlier between MSDE and Express is answered in my previous post of un-availability of SQL Agent Services in Express Edition.

I hope that at this point all your doubts are cleared ...if not please let us know.

Thanks
Rishi Maini

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources