1

We have two servers with two SQL Server instance. we have plan to make first one SQL Server 2016 for production database and the second one SQL Sever 2008 R2 for the same database as reporting side.

Can we create a replication solution between SQL Server 2016 & 2008 R2? If not: is there another solution to migrate updated data between these two instances?

asked Oct 22, 2016 at 15:50
3
  • First of all is it safe to use SQL Server 2016 in production ? Commented Oct 22, 2016 at 15:55
  • do you mean SQL Server 2016 not stable or under test? Commented Oct 22, 2016 at 16:20
  • Merge replication seems to be supported but not transactional replication. Microsoft Commented Mar 27, 2019 at 14:19

1 Answer 1

2

I'm afraid Replication between 2016 and 2008 is deprecated per Microsoft. MSDN Link

Replication is supported if each SQL Server endpoint is within two major versions of the current version of SQL Server. Consequently, SQL Server 2016 does not support replication to or from SQL Server 2008 or SQL Server 2008 R2.

answered Oct 24, 2016 at 14:01
1
  • I don't understand why you want to use 2 different versions though. If you use 2016 in both environments there will be no trouble. And 2016 is still bleeding edge and hasn't been used widely in Production environments which is why there is still hesitancy in using it. I saw a statistic that said .5% of active users use 2016 in Production at this time. 2008R2 is currently at the top at 38%. Commented Oct 24, 2016 at 14:04

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.