nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data Deployment for two databases at a time

kolli

Hi All,

I'm having a new requirement whenever data deployment is getting triggered it should be deployed to two databases and it should be transactional deployment i.e. if deployment to second database fails then first database deployment also should be roll backed.

Please help me on how to achieve this..

Thank you..

Regards,
Sashank

Find more posts tagged with

Comments

ISCBorisB

Hi All,

I'm having a new requirement whenever data deployment is getting triggered it should be deployed to two databases and it should be transactional deployment i.e. if deployment to second database fails then first database deployment also should be roll backed.

Please help me on how to achieve this..

Thank you..

Regards,
Sashank

I might be wrong but I do not think that you can do it simply by tinkering with DD Configurations.

What you are looking for is called "Two Phase Commit" or 2PC. DD does not provide this feature even
for Databases that support 2PC Protocol. One way or another, you'd have to code it yourself. Note
that 2PC implementations differ from DB to DB, some do not support it at all.