SQL 复制 - 简单地添加一篇文章是否会导致其复制？
我正在将 SQL 复制（事务性、具有许多订阅者的单一发布者/分发者，使用 SQL 2005）添加到网站，并在手册和 Google 上搜索了此内容。
我很好奇——我是否必须为要传播的新对象实际创建一个快照，或者是否将该新对象（例如表、存储过程、函数）添加到列表中将其传播到远程订阅者？
谢谢你，但我还是很困惑。 我有一个带有初始快照的标准事务复制，其中 Master SQL 2005 数据库确实与订阅节点（机器）同步。 但是，当我向发布者添加新的存储过程或表，并将它们作为文章添加到出版物时，它们似乎不会自动转移到订阅框。 检查订阅和发布者的属性似乎没有显示任何可以复制这些更改的设置。 （我确实打开了“复制架构更改”。）我必须缺少一些简单的东西...每次我创建新的存储过程或表或 UDF 时，我都必须生成新的快照，这不可能是真的整个数据库，是吗？
I am adding SQL Replication (Transactional, single-publisher/distributor with many subscribers, using SQL 2005) to a website and have searched everywhere in the manual and on Google for this.
I am curious -- do I have to actually create a snapshot for new objects to get propagated, or is adding that new object (e.g., table, stored procedure, function) to the list propagate it to the remote subscribers?
Thank you, but I'm still confused. I have a standard Transactional Replication with Initial Snapshot working, where the Master SQL 2005 database is indeed synchronized with a subscribing node (machine). But when I add new sprocs or tables to the publisher, and add them as an Article to the Publication, they do not seem to automatically carry over to the subscribing box. Checking properties of both the subscription and the publisher doesn't seem to reveal any setting that would replicate these changes. (I do have "replicate schema changes turned ON.) I have to be missing something simple... it can't really be true that every time I create a new sproc or table or UDF, that I have to generate a new snapshot of the entire DB, is it?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您需要运行快照，但它只会传播已更改的内容（新内容）。
You need to run the snapshot, but it will only propagate what has changed (what is new).
根据订阅的配置，您可能需要也可能不需要在添加新文章后显式更新它们。
MSDN 详细信息
Depending on the configuration of the subscriptions you may or may not have to explicitly update them after adding a new article.
MSDN Details