Search

SQLCMD Connect support in post deployment scripts by Tony Donley

Closed
as Won't Fix Help for as Won't Fix

1
0
Sign in
 to vote
Type: Bug
ID: 776293
Opened: 1/10/2013 2:45:47 PM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
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.
Details (expand)

Product Language

English

Version

SQL Server 2008 R2 SP2 CTP

Category

Developer Tools (SSDT, BIDS, etc.)

Operating System

Windows Server 2008 R2 Enterprise (SP1)

Operating System Language

US English

Steps to Reproduce

Include the ":Connection" command in a post-deployment script in SSDT

Actual Results

Build error

Expected Results

No build error

Platform

X64

Virtualization

 
File Attachments
0 attachments
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!

Thanks,
Adam Mahood
Program Manager
SQL Server Database Systems
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement