Sql-server – Data replication between SQL Server 2016 and SQL Server 2008 R2 is valid

sql serversql-server-2008-r2sql-server-2016

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?

Best Answer

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.