Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    London, UK

    Unanswered: Merging 3 SQL Server databases into one.

    How do I merge three SQL Server databases into one. There will be some duplicated information in some of the tables. Any help much appreciated. Thanks.

    P.S. Running SQL v7 on NT!!

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    A very general question for what is going to be a very complex task.

    Your primary concern will be Primary Keys. Are they duplicated across the databases (probably, unless you used GUIDs)?

    Your secondary concern will be Natural Keys. Duplicated natural keys will need to be collapsed, along with all child records.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

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