Need to run post-deployment script without schema change
I'm using post-deployment scripts to deploy SQL Agent jobs and other server-level objects, but the post-deployment script will not run unless there is a database schema change. What's the best way to do this? The only thing I can think of is to create a dummy database for this purpose and to deploy some kind of harmless change each time, but this seems like a hack.
0 · Share on Twitter