Truncate target Database first then insert the source data

VSinha · July 6, 2017 12:38PM

After comparing the Source and Target Databases, I need to deploy at the Target database after deleting all the existing rows in all the tables present including foreign key references. Basically Truncate target Database first then insert the source data.

Mark J · July 10, 2017 10:21AM

This isn't currently a feature in SQL Data Compare as far as I know, but you could write a script based on sp_MSForEachTable such as the one described here: https://stackoverflow.com/a/156813/895407 before doing the SQL Data Compare comparison. Would that work for you?

Truncate target Database first then insert the source data

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk