开发者

Adding to the schema of a subscribing database

开发者 https://www.devze.com 2022-12-30 00:32 出处:网络
Transactional Replication on SQL Server 2005 Enterprise x64 (SP3). I need to add check constraints to a databases that is the target for a replication, but I cannot add the check constraints to the p

Transactional Replication on SQL Server 2005 Enterprise x64 (SP3).

I need to add check constraints to a databases that is the target for a replication, but I cannot add the check constraints to the publishing database. The Problem is that the replication process keeps removing my constraints. How do I pr开发者_StackOverflowevent this?


You could create some ddl triggers to prevent the constraint being removed. however replication would fail horribly if you alowed the publishing database to publish data that violated the constraint, which is a distinct posibility if you cannot add the constraint to the master database.

0

精彩评论

暂无评论...
验证码 换一张
取 消