[askdba] Re: Merging Databases

  • From: Rajesh Puneyani <rajpuneyani@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Wed, 6 Oct 2004 15:35:16 -0400

Hi Justin,

You got it right.

That's precisely what I have to present in the management meeting.
These were 2 options which I already thought about but was wondering
if there is any detailed documentation with someone regarding
pros/cons of each strategy or any other method to accomplish the same.

All the databases are remotely located on different physical locations
so one of the method is going to be create all those databases in a
one central location on one big server.

Any hint on technical aspects of these would be helpful.

On Wed, 6 Oct 2004 13:22:09 -0600, Justin Cave (DDBC) <jcave@xxxxxxxxxxx> wrote:
> 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.
> http://www.ddbcinc.com/askDDBC
> -----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
> changes).
> 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
> documentation.
> Does anyone has any white paper or some documentation on this topic ?
> Any help would be more than appreciated.
> Thanks

Other related posts: