sqlsql-server-data-toolsdacpac

ssdt: versioning reference data with dacpac


Dacpac is nice solution for versioning schema and we have to use pre/post deployment to amend the reference data.

Any better solution to do that?


Solution

  • The best way I have seen is to use merge statements, one table per file and import them into your post-deploy script using :r imports.

    You get version history and easily comparable data and using sp_generate_merge makes it really simple.

    Ed