This code generates merge scripts for all tables within a specified database (As long as the tables to merge have primary keys on them). This script addresses the issue of the 'Load Order' of the data based on key constraints by disabling each tables referential constraint, merging the data, then reenabling the constraint after the merge is complete for each of the specified table(s).
Once executed, simply highlight the results within the following columns altogether and past into a new window:
Input parameters are:
The Code Above to Generate your initial Stored Procedure must be executed in the '@SOURCEDB' database to work.