DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: V Urgent: Commit across databases.

  1. #1
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Hi Gurus,
    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???

    Thanks!!!
    Hemant

  2. #2
    Join Date
    Jul 2001
    Location
    India
    Posts
    7

    hi hema

    Take this as the distributed database scenario and use the two phase commit proto. to full fill your data upgradations in production instance.

    Thanx
    venu

  3. #3
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262

    2 phase commit

    Hi Venu,
    I know that 2 phase commit has to be used but how do I use it???

    Thanks
    Hemant

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width