Setting up Publication on SQL Server 2008 R2 Express

Question

I cannot find the Local Publication folder in the node Replication in my SQL Server Management Studio.

I recently installed SQL Server 2008 R2 Express edition.

I also created two instances for testing purposes.

Solution for SQL Server 2005 is available here but not for SQL Server 2008 R2 Express

does 2008 express support replication ? I remember for sql 2005 express we had to install via a separate installer - and then we used to setup problematically (SMO) . — Baljeetsingh Sucharia, Feb 10 '13 at 08:43
We can subscribe to any server so publications also should be available — RAJ, Feb 10 '13 at 08:44
yes 2008 express can be subscriber , but can not be publisher ! see link i posted as answer. — Baljeetsingh Sucharia, Feb 10 '13 at 08:48

score 2 · Answer 1 · answered Feb 10 '13 at 19:13

According to Replication Considerations (SQL Server Express), a SQL Server Express Edition instance cannot be used as a Publisher or Distributor:

SQL Server Express cannot serve as a Publisher or Distributor.

However, a SQL Server Express Edition instance can serve as a Subscriber.

You will need a SQL Server Standard Edition instance or higher to configure a publication.

Baljeetsingh Sucharia · Answer 2 · 2013-02-10T09:48:04.083

0

Summarizing comments at one place - so it helps others,

SQL 2008 Express can not be used as publisher but can be used as subscriber.

edited Feb 10 '13 at 09:48

answered Feb 10 '13 at 08:46

Can you suggest how to publish in sql 2008 then? Also can u confirm the link is working? – RAJ Feb 10 '13 at 09:04
yes the i am able to read the link , try this alternate , published pdf of same , https://pdfzen.com/516214 . this should help – Baljeetsingh Sucharia Feb 10 '13 at 09:11
for sql 2008 setup - i recommend you to post a separate question - and not in this question - this way it would be clean stack over flow environment ( i am sure you will find many articles on setting up via sql 2008 server ) . – Baljeetsingh Sucharia Feb 10 '13 at 09:14
@RAJ hope you read link / pdf and now clear that can not create publication on sql express - if the answer is yes - please take the responsibility of marking it as answer so that it helps others. ping back if this didn't help – Baljeetsingh Sucharia Feb 10 '13 at 11:26
Thanks for the pdf I am investigating on it. and trying to set up using RMO. – RAJ Feb 10 '13 at 13:34
this is old post but curios to know what happened ? how it was solved ? – Baljeetsingh Sucharia Mar 04 '14 at 16:39

2 Answers2