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: 553
        
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