Post reply

publishing sql 2008 R2 to 2005

  • October 4, 2010 at 12:54 am

    #387931

    Is there a way to publish a sql server 2008 R2 database to a sql server 2005 subsriber.

    I would like to do this as I am looking for a rollback plan for some of my VLDBS when upgrading for sql 2005 to 2008 R2.

  • October 5, 2010 at 3:28 am

    #1231542

    Yes, you can do even to SQL 2000 subscriber. 2008 is backward compatible for last 2 versions.

    Shiva

  • December 21, 2010 at 8:55 pm

    #1265343

    this is a further question along the same lines..

    due to time phasing of upgrades, there will be a time gap in migrating all servers to SS2008 (on Windows Server 2008).

    So, for some time we will have :

    publisher in SS008 EE 64;

    distributor and subscriber in SS2005 EE 64.

    Have anybody done that and get it to work OK?

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

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