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