1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Merging two SQL databases same schema just different data

Discussion in 'Windows Server System' started by 3zzi32008, 2008/10/15.

  1. 2008/10/15
    3zzi32008

    3zzi32008 Inactive Thread Starter

    Joined:
    2008/02/07
    Messages:
    35
    Likes Received:
    0
    Hi All,

    I have been given the task to merge to SQL databases together which consist of exactly the same tables etc, but just consist of different data.

    I have never done anything like this before,:eek: and don't have a clue on how to start this but am aware that it is possible.

    Any advice would be much appreciated. :D

    Kind Regards
     
    3zzi32008,
    #1
  2. 2008/10/15
    Steve R Jones

    Steve R Jones SuperGeek Staff

    Joined:
    2001/12/30
    Messages:
    12,315
    Likes Received:
    252
    On one hand I'm not an export...On the other hand I support an accounting software that uses SQL databases.

    Almost everthing that is entered in the database (db) is assigned an internal ID number. Merging to db's that could have also sorts of identical ID's through out the db's would be a really really BAD thing.
     
    Steve R Jones,
    #2


  3. to hide this advert.

  4. 2008/10/16
    3zzi32008

    3zzi32008 Inactive Thread Starter

    Joined:
    2008/02/07
    Messages:
    35
    Likes Received:
    0
    Hi, and thank you for your response. I am aware that every record entered has its own internal ID and most certainly the 2 databases will contain records which share the same IDs, however I am also aware that there is a way to do this and I would have thought it would be by re-assigning ID's to the records.

    If you have any idea on how I can go about this it would be great.

    Thanks again.
     
    3zzi32008,
    #3

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...