No announcement yet.

Merging DBs

  • Filter
  • Time
  • Show
Clear All
new posts

  • Merging DBs

    Right now we have 3 instances in production: a 4.0 instance, a 4.5 instance and a 5.5 instance. All 3 instances are live with customers (diff ones of course). I am currently undergoing the project of preparing to upgrade 4.5 to 5.5. The upgrade itself, I am not worried about. However, a request has been made to look into merging the 4.5 and 5.5 databases into 1 instance upon completion of the upgrade (and later the 4.0 db into the same instance as well).

    What I am concerned about is the effect of moving transactional data into another db with other customers due to duplicate/conflicting I_trans, sequence numbers, etc (not to mention the differences in the customized public domain - but thats doable). It wouldn't be so bad if these were just visiblity customers or promoting base data - but these are the full deal from orders - to bulk planning to invoices (both buy and sell) and am quite concerned at the effect it will have on the data integrity.

    I wondered if any of you had successfully done the same and found a way around this. I also entered a ticket into Oracle a few days ago, but was going to check on here to see if any of you had experiences with such.