Post reply

Configure Replication between SQL SQL SERVER 2008(Publisher) & SQL SERVER 2000(Distributer,subscriber )

  • April 16, 2010 at 8:35 am

    #220610

    Hi Guys,

    We have plan to upgrade one of our servers and install SQL SERVER 2008,and also we have plan to confugure a Transactional replication.The Server (SQL SERVER 2008) is the publisher and the distributer and Subscriber are SQL SERVER 2000.Is is possible to configues Transaction replication between SQL SERVER 2008(Publisher) & SQL SERVER 2000(Subscriber & Distributer).

    Thanks

  • April 19, 2010 at 3:21 pm

    #1154173

    According to BOL the distributor will need to be on the 2008 server.

    A Distributor can be any version as long as it is greater than or equal to the Publisher version (in many cases the Distributor is the same instance as the Publisher).

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

  • April 23, 2010 at 9:24 am

    #1156962

    Yes, You can.

    [font="Verdana"]--www.sqlvillage.com[/size][/font]

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

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