Home Forums SQL Server 2014 Development - SQL Server 2014 Dynamic SQL to move data from from database to another taking into account identity keys RE: Dynamic SQL to move data from from database to another taking into account identity keys

  • Scratch that...my idea of storing anything in memory obviously won't work because there is no shared memory between the source and destination since all I'm delivering to the destination is a set of INSERT scripts to run.

    I may have to script out the contents of my source table as a separate insert into a temp table on the destination so that I can then add the crosswalk key from the newly inserted table...doesn't sound fun.