Post-deploy command-line in database project?

Question

Hello,

I have a database project in Visual Studio 2010. After the database is deployed (not after it is built) I want to execute a DOS command-line in the same way that can be done for the Post-build event.

Does anyone know how to do this?

Answer 1

0

I believe the post-deployment scripts support SQLCMD syntax.

I haven't done this myself, but try calling the command line from your post deployment sql script

:!! <path-to-your-batch-file>

the list of commands supported by SQLCMD can be found in Books Online - http://msdn.microsoft.com/en-us/library/ms162773.aspx

answered Jul 28 '11 at 09:29 AM

KenJ
12.4k ● 2 ● 10

(comments are locked)

Answer 2

0

You can define a post-deploy event in the project file, even though the GUI doesn't expose this. e.g.

<PostDeployEvent>"$(MSBuildProjectDirectory)\BuildTools\mypostbuildtool.exe"</PostDeployEvent>

answered Aug 13 '12 at 07:29 PM

craigfis
0

(comments are locked)

Post-deploy command-line in database project?

Follow this question

Related Questions