This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 请教MS SQL数据库数据复制、更新问题：两个数据库，能不能只有当源数据库的一个记录指定的字段被更新，才自动复制该记录到目标数据库中？（如果该记录已存在目标数据库中，就更新目标记录。）谢谢！
-hillxie(阳光、绿地、鸽子);
2004-7-14
(#1801962@0)
-
trigger + linked server
-yangn(Raymond);
2004-7-14
(#1801990@0)
-
谢谢！我只考虑到了linked server，但忘了用trigger。我一直在考虑Replication，但是总实现不了这个目的，请问你觉得Replication有没办法做这个事情？
-hillxie(阳光、绿地、鸽子);
2004-7-14
(#1802046@0)
-
Yes. You can use vertical filter to specify what column to be replicated.
-yangn(Raymond);
2004-7-15
(#1802616@0)
-
Thanks. I tried this before, it is not that easy for me to reach my goal by this way.
-hillxie(阳光、绿地、鸽子);
2004-7-15
(#1802789@0)
-
Then the easier way is to try trigger + linked server
-yangn(Raymond);
2004-7-15
(#1802867@0)
-
Yes. I think vertical filtering by column in Replication is not enough to reach the goal, am I right?
-hillxie(阳光、绿地、鸽子);
2004-7-15
(#1803033@0)
-
Theoritically the replication works for your goal. But linked server solution is much easier.
-yangn(Raymond);
2004-7-15
(#1803090@0)
-
I gave up the Replication, I can not find a way to make it work for this case. Thank you very much.
-hillxie(阳光、绿地、鸽子);
2004-7-15
(#1803135@0)