Search code examples
sqldeploymentsql-server-data-tools

Publish data with SSDT with new feature Build Contributors and Deployment Plan


I have a SSDT-project. When publishing a new version I want to publish/initialize some data motion in the database as well. This can be done with new feature, but how ? Announcing SQL Server Data Tools - June 2013


Solution

  • Probaly using a Post Deployment Script.

    You create the script to modify the data and include it in your post deployment script file.

    I am assuming you have the script itself already, otherwise that is propably a separate question. For static data, Merge-statements are my recommendation.