Post reply

SQL Replication

  • November 4, 2011 at 4:26 pm

    #247292

    Hi All,

    Is it possible to mix SQL Server editions for transactional replication? For example, can the publisher be SQL Server 2008 R2 Enterprise edition and the distributor be SQL Server 2008 R2 Standard edition and the subscriber be SQL Server 2008 R2 Enterprise edition...

    Thanks in advance for the help.

  • November 4, 2011 at 4:46 pm

    #1403537

    AFAIK it's possible but you'll have to be careful with difference on features between Enterprise and Standard editions.

    More info here:

    http://blogs.msdn.com/b/repltalk/archive/2011/01/03/replication-features-in-various-editions-of-sql-server-2005-2008.aspx

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • November 7, 2011 at 10:12 am

    #1404080

    You can.

    The subscribers can only be the same version or 2 lower to the publisher. You need to be aware of datatype and feature differences used across versions.

    Otherwise its pretty much identical.

    This is the link.

    For all types of replication, the Distributor version must be no earlier than the Publisher version. (Frequently, the Distributor is the same instance as the Publisher.)

    For transactional replication, a Subscriber to a transactional publication can be any version within two versions of the Publisher version. For example, a SQL Server 2000 Publisher can have SQL Server 2008 Subscribers, and a SQL Server 2008 Publisher can have SQL Server 2000 Subscribers.

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

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

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