Replication features in various editions of SQL Server 2005/2008


Replication features in various editions of SQL Server 2005/2008

Sateesh Yele
Microsoft SQL Server Support

The following table lists the features in the Replication area and their presence/absence/limitation in each edition of SQL Server.

 

Feature

Express

Express Advanced

Workgroup

Standard

Enterprise

Web

Evaluation

Developer

Merge Replication

Subscriber only

Subscriber only

<= 25 subscribers

Y

Y

Subscriber only

Y

Y

Transactional / Snapshot  Replication

Subscriber only

Subscriber only

<= 5 subscribers

Y

Y

Subscriber only

Y

Y

P-P Transactional Replication

N

N

N

N

Y

N

Y

Y

Oracle Publishing

N

N

N

N

Y

N

Y

Y

 

posted by: Chris Skorlinski

Comments (1)

  1. Marc says:

    Do you know where I can find a detailed list of what is supported in each version?

    I am running the Dev edition but will likely be using Standard in production. When I set up replication in my dev environment I was told that 'indexed views' would not be supported. I can't seem to find any web page where all the small details (such as this) are listed. Would be great if someone could post that info.