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?
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
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, 2011 at 09:29 AM
You can define a post-deploy event in the project file, even though the GUI doesn't expose this. e.g.
answered Aug 13, 2012 at 07:29 PM