Post reply

Transactional replication between SQL2005 & SQL2008

  • November 7, 2011 at 8:12 am

    #146621

    Afternoon,

    I am in the process of designing a process to transport data from our production database server to a 'warm' reporting server. I thought that transactional replication would be a good fit for this but I believe I may have hit a slight obstacle now.

    My question is this:

    Is it possible to have a SQL2005 Publisher & a SQL2008 subscriber when using Transactional Replication? The compatibility level of the production database is 90 and the SQL2008 database engine & reporting service can be changed to support this (if required)

    I have read the folllowing link from MS: http://msdn.microsoft.com/en-us/library/ms143241.aspx but I am still unsure as to whether this supported? The only bit I can see that definitely says this is not supported is the Web Synchronization.

    Thanks in advance guys 🙂

    Dan

  • November 8, 2011 at 3:08 am

    #1404335

    I've now found several locations on the net that illustrate it is possible to have transactional replication setup between a SQL 2005 Publisher & SQL 2008 Subscriber so my question is now answered.

    Thanks 🙂

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

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