I have a Database project which uses a SQL Server Express 2008 database.
I am installing the database using sqlcmd and using the SQL Script generated as an output from the database project.
There is a snippet below from the SQL Script generated. This sqlcmdvars are language and architecture specific.
How do I make a generic set of sqlcmdvars which will work for "Program Files" or "Programme" or "Program Files(x86)" or "Programme(x86)"?
Snippet from SQL Script used by SQLCMD:
:setvar DatabaseName "TestDatabase"
:setvar DefaultDataPath "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\"
:setvar DefaultLogPath "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\"