Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We move from sql 2008 standard to express. I know publication/subscription is not allowed in sql 2008 express. I would like to know if is any other option for replication in express version?


share|improve this question
What was your reason for moving to a lower grade version of the product? Were you aware that you were going to lose the ability to have a replication publisher? – DanBig Jul 14 '10 at 13:10
up vote 2 down vote accepted

SQL Server 2008 Express may participate as a subscriber, it just cannot be a publisher. However, two-way merge replication is supported.

share|improve this answer
I already know what you said. So i need any new solution if exist? – senzacionale Jul 4 '10 at 18:47
Your post says that subscription is not allowed, which is not true. I was clarifying that subscription is allowed, in case you just need to subscribe and not publish. – Stephen Jennings Jul 4 '10 at 19:09
+1 for what I would consider a valid and valuable answer. @senzacionale: Hopefully it wasn't you that downvoted this answer. Your question leaves a lot open to assumption and interpretation (of what you know or don't know about SQL Express) and Stephen's answer offered you information you may or may not have known. Downvoting on good answers to your questions is not likely to get you many answers here. – joeqwerty Jul 4 '10 at 19:27
no i didn't vote anything. I never downgrade voting... – senzacionale Jul 5 '10 at 4:11

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.