SQLCMD Variables

ChrisYates

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

ChrisYates

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.