在使用AWS DMS服务设置订阅副本时,添加一个新的文章到事务复制中。

huangapple go评论56阅读模式
英文:

Adding a new article in Transactional replication when subscription replica is setup using AWS DMS services

问题

如何在使用AWS DMS服务设置了辅助副本的SQL Server 2017上添加新表到现有的事务复制中?

在设置过程中,我们只在SQL Server上创建了分发和发布,客户团队使用AWS DMS创建了发布的端点(我不确定客户是如何使用AWS DMS服务创建端点的)。

现在我需要在此发布者中添加一个新文章,理想情况下,我会将设置中的Allow_anonymous和Auto_sync设置为false,并添加新表并重新初始化快照/订阅者。但由于在SQL Server上没有任何订阅(无法通过SSMS查看),我无法重新初始化快照。

请问有人能告诉我添加新文章到复制中需要执行哪些步骤?或者是否需要从AWS DMS方面执行任何新步骤来重新初始化快照。

英文:

How do I add a new table to an existing transaction replication on SQL server 2017 where secondary replica is setup using AWS DMS service?.
While setting up we have only created distribution and publication on sql server and the client team had created endpoint for the publication using AWS DMS (I am not sure exactly how client had created endpoint using AWS DMS service).

Now I have a add a new article in this publisher which ideally I do my setting on Allow_annonymious and Auto_sync to false and add new table and reinitiate the snapshot/subscriber. but since I dont have any subscription present on SQL server (not able to see via SSMS) I am nit able to reinitiate the snapshot.

Can someone please tell me if what steps I need to perform to add a new article in replication OR any new steps are required form AWS DMS side to reinitiate the snapshot.

答案1

得分: 0

我想回答你的问题。
如果我们需要在已有的复制中重新添加一篇新文章,该复制与AWS DMS服务结合作为副本。

我们只需要在发布者中重新添加新文章,方法是进入发布者属性。我们不需要将Allow_annonymious和Auto_sync设置为false。添加完成后,我们需要在AWS端执行FULL LOAD操作,以创建一个新的快照副本。

另外,我还注意到,如果我们在SQL中创建了任何带有主键的新表,它会自动添加到复制中。如果我们不希望考虑该表进行复制,我们需要手动从发布者中删除该文章。

英文:

I would like to provide an answer to my question.
If we have to re-add a new article in an existing replication which is combined with AWS DMS service as a replica.

We simply need to re-add the new article in the publisher by going into publisher properties. We not have to set Allow_annonymious and Auto_sync to false. Once added we have to perform a FULL LOAD on AWS side to make a fresh copy of snapshot.

FYI, I have also noticed that if we create any new table with PK key in SQL it is automatically added into replication. We have to manually remove that article for publisher if we dont have to consider it for replication.

huangapple
  • 本文由 发表于 2023年7月27日 15:55:51
  • 转载请务必保留本文链接:https://go.coder-hub.com/76777601.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定