Using two different edition of SQL SERVER 2008 in Transactional Replication

Question

Using two different edition of SQL SERVER 2008 in Transactional Replication

Aspet Golestanian Namagerdi

SSCarpal Tunnel

Points: 4444
More actions
September 14, 2010 at 3:01 pm

#226349

We have plan to migrate to SQL SERVER 2008 R2.Is it possible to build Transactional replication with the following structure:
Publisher:SQL SERVER 2008 R2 Enterprise Edition
Distributer:SQL SERVER 2008 R2 Standard Edition
Subscriber:SQL SERVER 2008 R2 Standard Edition
Is using different edition of SQL SERVER 2008 R2 Possible in Transactional Replication?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 738642 More actions · Answer 1

yes, the editions are less important than the versions. Some editions cannot be publishers, but I believe all can be subscribers

http://msdn.microsoft.com/en-us/library/ms143241.aspx

Aspet Golestanian Namagerdi SSCarpal Tunnel Points: 4444 More actions · Answer 2

Thanks a lot for your reply.Then it is ok,I f I use Standard Edition(SQL SERVER 2008 R2) for Distributor and Enterprise Edition(SQL SERVER 2008 R2) for Publisher.