VS2010 Database Project - BAT file in post deployment script

Hello,

  I have a bat file containing bcp commandwhich I attached/added under Post-Deployment folder in database project.  
  I want to inkove this batch file from post-deployment script (Script.PostDeployment.sql).

  How do I do it?

  I tried by including the following in the post-deployment script, but it throws "Error SQL01268: SQL Execution error: Scripting warning. Command ExecuteShellCommand is not supported." error.

:!! New_Rebuild_Admin.bat

Open in new window


 
Thanks!
sath350163Asked:
Who is Participating?
 
jogosConnect With a Mentor Commented:
exec xp_cmdshell

But this can be disabeled
0
 
Eugene ZConnect With a Mentor Commented:
check

•How to: Specify a Pre-build or Post-build Command Line - http://msdn2.microsoft.com/en-us/library/aa833213(VS.80).aspx
 •Pre-build Event / Post-build Event Command Line Dialog Box (Team Edition for Database Professionals)  - http://msdn2.microsoft.com/en-us/library/aa833259(VS.80).aspx
 
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.