versions for distributor and publisher different

  • hi i have a sql instance sql 2008 r2 sp2. I would like to create a sql 2012 sp1 instances as its distributor and subscriber instances. Is it possible to have the publisher as sql 2008 r2 sp2 and distributor and subscriber sql 2012 sp1?

  • It may be possible, but it may be not under support. I currently have a SQL 2000 publisher with a SQL 2008 distributor/subscriber. You will likely want to have the log reader job run on the publisher.

    You would have a better chance of getting it to work with the SQL 2008 R2 box being the distributor and publisher, and leaving the SQL 2012 box as only the subscriber.

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

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