I'm using SQL Server 2008 R2 and I'd like to copy all data rows from one table of a test database to the identical table in a production database. The primary key of the table is referred to by other tables so a DELETE followed by a number of INSERTs
won't do it because of referential integrity issues. What is the best method to replace the data rows in the destination database with the values from the source database?
View Complete Post