SQLCMD Variables

[cyates04]

I have a set of SQL scripts that utilize SQLCMD Variables......for example


:setvar Pub_Server "[team-1]"
:setvar Sub_Server "[team-1\Reporting]"
:setvar SubscriberDB "Reporting_team1"
:setvar PostSnapshotScript "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\repldata\index\indexfile.sql"

I've changed my variable names but you should be able to see the gist of what I am trying to accomplish. This portion of the script is at the top of my SQL script and will be called later on in the script. This works well in SSMS but doesn't using this utility. I receive a error - Incorrect syntax near ':'.

Is the use of SQLCMD Variables not supported with this utility? I could break the script out into 5 different variations and hard code in the values but trying to stay away from that.

[dlkj]

Hi cyates04,

SQL Multi Script doesn't support SQLCMD variables. We have rough feature parity with SSMS which doesn't support them either.

Thanks,
--
Daniel

[cyates04]

Thanks for the quick response.

[dcam]

Hi,

The SQLCMD syntax is supported by management studio. Using the 2008 client there is the option under the query menu to execute scripts using the SQLCMD syntax.

Will there be support for SQLCMD syntax in future versions on MultiScript?

David

[dlkj]

Hi David,

Thanks for letting us know about that. It's amazing what's hidden in SSMS.

Unfortunately we aren't planing to make any updates to SQL Multi Script in the immediate future.

Daniel.