如何将数据从SQL Server 2017复制到SQL Server 2008 R2 [英] How can I replicate data from SQL Server 2017 to SQL Server 2008 R2

问题描述

我需要将表中的数据从运行SQL 2017的数据库复制到运行SQL 2008 R2的服务器。只需要在接下来的8-12周内进行复制，并且只需从SQL 2017开始一次 - > SQL 2008 R2。我不需要每天进行实时复制。
服务器在Hyper-V中的同一物理服务器上作为虚拟实例运行。这是一个会员数据库，大小约为5 GB。每天的数据更改通常少于50 MB。

我知道我不能使用事务复制。我可以使用合并复制吗？我有什么选择？

感谢您的时间和答案。

解决方案

不支持事务复制作为向后兼容性仅支持SQL 2014 for SQL 2017.
因此，您的唯一选择是合并复制。我会考虑为您的方案使用快照复制

希望这有帮助！

- -------------------------------------------------- ---------------------- --------------------------------

请不要忘记" mark 
回复为答案 " 如果有帮助，也设置" 喜欢 "
这是我们保持博客的一个推动力  J

点击  here  到
了解详情。访问专用的 社区 论坛    分享 ，  探索  和  谈话 &
专家关于Microsoft Kaizala。

I need to replicate the data in tables from a database running SQL 2017 to a server running SQL 2008 R2. The replication is only needed for the next 8-12 weeks and only one way from SQL 2017 -> SQL 2008 R2. I don't need real time replication, just daily. The servers run as virtual instance on the same physical server in Hyper-V. This is a membership database and is roughly 5 GB in size. There is usually less than 50 MB in data changes per day.

I know I can't use transactional replication. Can I use merge replication? What choices do i have?

I appreciate your time and answers.

解决方案

The Transactional replication is not supported as the backward compatibility is supported only till SQL 2014 for SQL 2017. So your one and only choice is to Merge Replication. I would think of using the snapshot replication for your scenario

Hope this helps!

---------------------------------------------------------------------------------------------------------

Please don't forget to "mark the replies as answers" if they helped, also set "like" it’s a boost for us to keep blogging J

Click here to learn more. Visit the dedicated Community forum to share, explore and talk to experts about Microsoft Kaizala.

这篇关于如何将数据从SQL Server 2017复制到SQL Server 2008 R2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！