[askdba] Re: Merging Databases

  • From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
  • To: <askdba@xxxxxxxxxxxxx>
  • Date: Wed, 6 Oct 2004 13:22:09 -0600

Can you define "merge" here a bit more precisely?  In particular, are
you going to be creating a number of schemas in a single database, one
per application?  Or will you be trying to integrate data from each of
these applications into a single database schema?

Justin Cave  <jcave@xxxxxxxxxxx>
Distributed Database Consulting, Inc.

-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]
On Behalf Of Rajesh Puneyani
Sent: Wednesday, October 06, 2004 2:27 PM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Merging Databases

Hi guys,

I have to present a detailed proposal/technical plan of merging a few
databases of similar functional nature (not essentially similar DB
objects) without changing the application (or minimum possible

e.g. Several customer Information databases will have customer
specific data but underlying tables etc could be different in all of
them. The Requirement is to merge them.

I have a few strategies to achieve that but to elaborate upon them and
see if there could be more strategies, I was looking for some external

Does anyone has any white paper or some documentation on this topic ?
Any help would be more than appreciated.


Other related posts: