Devart Forums

Hi

What i would like to do is to have various distributed processes (could be on multiple physical or virtual machines) do processing on cached data. Once all the processing is complete i need to commit the processed data to the database using a single DB transaction. Is it possible to somehow tell SQL server to combine a set of connections from a transactional point of view?

After Execute (Either all processes should successfully save or all should roll back)

Process \
Process -- DB
Process /

Thanks
Ben

SDAC supports distributed transactions only in the same application. You can use the TMSTransaction component for managing transactions in an application. It is based on the Microsoft Distributed Transaction Coordinator functionality.

Thanks for answering Dimon.

I had a quick look at the Microsoft Distributed Transaction Coordinator functionality and it seems to me that what i need it technically possible, but as you say not implemented currently in SDAC.

Does Devart have any current plans to implement said functionality?

Thanks

We will investigate the possibility of adding this functionality in the near future. As soon as we solve this question we will let you know.