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

    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
    Location
    Ohio
    Posts
    12,592
    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
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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