CODEWITHSUNDEEP
databasevisual-studio-2008
Ana Betts
Ana Betts

Reputation: 74654

Why don't post-deployment scripts run in VS2008 database projects?

I've got a VS2008 database project, and I created a post-deployment script under Scripts > Post-Deployment, but it appears to be a no-op (even when I put syntax errors into the file, everything succeeds). The rest of the database deployment succeeds though (and it does create my tables). Any clues?

Upvotes: 1

Views: 974

Answers (1)

Ed Altorfer
Ed Altorfer

Reputation: 4371

It sounds like you're just placing scripts in your post-deployment directory. You actually need to include them in your Script.PostDeployment.sql file. For example:

:r .\MyScriptName.sql
:r .\MySecondScript.sql

Not every script in the Post-Deployment folder just runs by default; in fact, only one can. By default, it's that Script.PostDeployment.sql file. You can change it if you want.

Upvotes: 3

Related Questions