Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Copying data from one set of tables to another RE: Copying data from one set of tables to another

  • March 27, 2014 at 11:09 am

    #1700811

    ErikMN (3/27/2014)

    Thanks for the reply, but I think you're missing one part of my scenario or I'm not quite understanding your answer. The problem with your answer is that I want to take data from one database to another database that already has data in tables that the data is going into.

    For example,

    DB1 - Table1 has IDs 1-1000

    DB2 - Table1 has IDs 1-500

    I'm wanting to add records with IDs 1-1000 to the second table but also making sure the references in other tables point to the correctID from Table1.

    My bad here, misunderstood the question. My thought is to update all references as part of the load, a mapping solution might become very hard to maintain.

    Are there overlaps in the referential data?