I have two instances. Staging and Production.
A change is made in staging and this is inserted /updated in production.
But until a commit is performed in production, I cannot commit it in Staging
How would I check for this and implement it in my stored procedure???
Take this as the distributed database scenario and use the two phase commit proto. to full fill your data upgradations in production instance.
2 phase commit
I know that 2 phase commit has to be used but how do I use it???
Click Here to Expand Forum to Full Width