Can I modify package.xml file in SQL bootstrapper to install a named SQL server instance
Posted
by jonmiddleton
on Stack Overflow
See other posts from Stack Overflow
or by jonmiddleton
Published on 2010-04-08T22:28:54Z
Indexed on
2010/04/08
22:33 UTC
Read the original article
Hit count: 485
I want to use the SqlExpress2008 Bootstrapper for a new installation on Windows7, I do not want to use the default SQLEXPRESS Instance.
I have attempted to edit the package.xml file located in: C:\Program Files\Microsoft
SDKs\Windows\v7.0A\Bootstrapper\Packages\SqlExpress2008\en\package.xml
and updated the command argument instancename=CUSTOMINSTANCE
But unfortunately it still creates the default SQLEXPRESS not CUSTOMINSTANCE
The wix tag is as follows:
<sql:SqlDatabase
Id="SqlDatabaseCore"
ConfirmOverwrite="yes"
ContinueOnError="no"
CreateOnInstall="yes"
CreateOnReinstall="no"
CreateOnUninstall="no"
Database="MyDatabase"
DropOnInstall="no"
DropOnReinstall="no"
DropOnUninstall="no"
Instance="[SQLINSTANCE]"
Server="[SQLSERVER]">
<sql:SqlFileSpec
Id="SqlFileSpecCore"
Filename="[CommonAppDataFolder]MyCompany\Database\MyDatabase.mdf"
Name="MyDatabase" />
<sql:SqlLogFileSpec
Id="SqlLogFileSpecCore"
Filename="[CommonAppDataFolder]MyCompany\Database\MyDatabase.ldf"
Name="MyDatabaseLog" />
Is this the standard way to accomplish this?
© Stack Overflow or respective owner