CODEWITHSUNDEEP
visual-studiosql-server-data-toolsdatabase-projectsql-scriptsbuildaction
Dib
Dib

Reputation: 2093

The difference between "Build", "Compile" and "None" Build actions in Visual Studio Database project

Although I can find (on the web) a lot of information about the PreDeploy and PostDeploy Build Action for SQL scripts in a Visual Studio 2012 Database project and I understand that None does not compile or include the script when deploying, please can any one definitively advise or direct me to an article that does definitively define the subtleties of Build and Compile?

My rough assumption is both of these will compile against the schema, but only Build will be deployed. Is this correct?

What I would like is the correct setting to validate my seeding scripts against the current schema (and cause a build error on invalid schema structure) but to NOT deploy with a database publish or show up in a schema compare session.

Upvotes: 11

Views: 8710

Answers (2)

TTT
TTT

Reputation: 29064

I just found this out the hard way, but apparently a typo such as "Built" (instead of "Build") acts the same way as "None". I haven't confirmed, but presumably any word that doesn't match a valid value will be treated the same way as "None" and the build will just skip it.

Side Note: I think I'd probably prefer the build to fail on an unknown value, but it should be easy enough to script a gated-checkin to detect it too.

Upvotes: 0

Steven Green
Steven Green

Reputation: 3517

In a database project, "Build" is used for sql files and "Compile" is used for C# or VB (i.e. SQL CLR) files. When building a database project, the output is a dacpac file containing the processed "Build" sql files and a .NET assembly (dll) file containing the processed "Compile" C# or VB files.

Files marked as "None" are simply ignored.

Upvotes: 4

Related Questions