Kamil Nowinski shows how you can script out and deploy data as part of your SSDT database project:
It’s a very common scenario when we have a database (project) and require some data in selected tables even in the freshly deployed, empty database.
Nomenclature for these data/tables that you can meet are:
– reference data
– master data
– dictionary
Which term have you heard and is closest to you?By default, SSDT does not support scripting or deploying the data.
Hence: the question is: how we can cope with that?
Read on for the answer.