是否可以在 SQL 2005 标准发布服务器和 SQL 2008 Web 订阅服务器之间设置复制 [英] Can Replication be setup between a SQL 2005 Standard Publisher and SQL 2008 Web Subscriber

问题描述

我目前只有一个 SQL 2005 服务器.我想复制到 SQL 2008 Web Edition 服务器.是否可以设置从 SQL 2005 标准版发布者到 SQL 2008 Web 版订阅者的复制.复制类型的最佳选择是什么?这个设置有什么大问题吗?

I am currently have a single SQL 2005 server. I would like to replicate to a SQL 2008 Web Edition server. Is it possible to setup replication from a SQL 2005 Standard Edition publisher to a SQL 2008 Web Edition subscriber. What is the best choose for replication type? Are there any major problems with this setup?

推荐答案

有可能吗?(版本功能支持)

复制类型实际上取决于您将数据用于什么

Replication type is really down to what you are going to use the data for

如果它的双向实时数据发生变化，那么合并复制可能是最合适的.如果您需要更多数据用于报告目的，那么交易或快照可能会更好.

If its two way live data changes then merge replication is probably most appropriate. If you need data more for reporting purposes then transactional or snapshot might be better.

MS 有一些不错的 msdn 页面关于评估复制.从个人经验来看，如果预算允许它第一次获得顾问，特别是如果它的任务在短时间内是关键的.事情可能会出错或以意想不到的方式运行(并且错误处理并不总是很明显.)

MS have some good msdn pages on evaluating replication. From personal experience if the budget will allow it get a consultant the first time especially if its mission critical in a short time. Things can go wrong or behave in unexpected ways (and the error handling is not always obvious.)

这篇关于是否可以在 SQL 2005 标准发布服务器和 SQL 2008 Web 订阅服务器之间设置复制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！