Truncate target Database first then insert the source data

VSinha

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

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?