开发者

Implement a 3-phase commit in c#/t-sql

Simple question, probably an easy answer but 开发者_运维问答google-fu seems to be weak this morning: can't find any information.

I've got a SQL Server 2008 back-end and a .net front end written in C#. I'm changing a database copy job that's administered through c# from copying one-to-one to one-to-many target databases. As part of this job I need to ensure that the data copy uses a 3-phase commit before writing. However I can find absolutely no references anywhere as to how to implement this in Microsoft technologies.

Can anyone either help here, or point me at something useful, preferably with examples?

Cheers, Matt


Is there a reason that you must have 3-phase? SQL Server comes out of the box with two-phase commits using MSDTC: MSDN article.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜