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