Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mattt
Posting Yak Master
194 Posts |
 Posted - 2011-01-13 : 04:53:34
|
| Hi,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 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-01-13 : 12:28:27
|
| Cant you just set up replication between the databases?PBUH |
 |
|
|
|
|
|
Implement a 3-phase commit