SQLCMD Connect support in post deployment scripts - by Tony Donley

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 776293 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/10/2013 2:45:47 PM
Access Restriction Public


Post-deployment scripts in SQLCMD mode do not support the Connect command to switch execution context to a different server.  It would be great if any valid SQLCMD syntax could be supported.
Sign in to post a comment.
Posted by Microsoft on 1/25/2013 at 12:49 PM
Hey Tony,

Thank you for your feedback regarding supporting the :connect SQLCMD statement in SSDT scripts. At this time, we do not have any active plans to expand the set of SQLCMD syntax supported by SSDT, including this connect statement.

Thank you again for taking the time to submit feedback and let us know if you have any other questions/comments!

Adam Mahood
Program Manager
SQL Server Database Systems