While SQL Server Data Tools doesn’t quite that level, it gets very close. The holy grail of database development is the ability to treat database objects as if they were normal source code.

In SQL Server Data Tools, I handle this using a post-deployment script. In this script, I populate a temporary table with what the data should look like, then use a MERGE statement to update the ...