How can we help you today? How can we help you today?

Truncate target Database first then insert the source data

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.
Vijay
0

Comments

1 comment

Sort by
  • 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?
    Mark J
    0

Add comment

Please sign in to leave a comment.