How to import data into a Visual Studio 2012 Sql Server Database Project

Question

I am considering Sql Server Database projects. It seems to import the schema and stored procedures from the database, but there is no mechanism to import the actual data. As part of our build process, we usually import both the schema and the data.

Can this be done from Sql Server Database projects?

Answer 1

The current solution is to use the reference data to deploy the script. The script must be written as idempotent because it does not know the state of the target. This is described in detail here:

Incorporating data into a SQL Server database project