Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
Download in .rgtool format for use with
SQL Scripts Manager, a free tool that provides simple GUIs for SQL scripts.
By Michael Taylor,
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.
Constraint with a check
Violating the primary key constraint
Triggers - Constraints