Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Nasik, Maharastra

    Unanswered: How to merge multiple databases mannually in MS SQL server.

    Hello Masters,

    Recently i got one assignment from my senior, I have to merge multiple sql server databases, I am confuse about:
    What is action plan?
    Where to start?
    How to start?
    What prerequisites should consider?
    What factor will cause error, how to tackle that error.

    Looking forward to learn something from you.

    Thanks and Kind Regards,

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    There is a heck of a difference between merge replication, database consolidation, and combining multiple schemas into a single database. You senior could have meant any of these choices or something completely different. Without understanding what you are to accomplish, there is little or no chance of success!

    Your first step needs to be to discover what your senior means... Merging databases is not a well defined term. They may mean one or more of many things, and without knowing what they want there is little or no chance that you'll accomplish that goal!

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jul 2003
    San Antonio, TX
    Look into synonyms. Lately I introduced this trick at one of my clients' sites, when they has to separate their main database into several databases, but did not want to change any fron-end code. You can successfully use it ONLY if schema names are different in each database you want to "merge" using this technique.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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