[wix-users] Wix - Create Database takes long time.

[Ashutosh Vyas]

Hi All,

 

I am creating an installer using wix. Everything seems to be fine. However,
Creating of Database takes lot of time. It almost sticks at "Creating
Databases" for close to 15 min and does the task of just Creating a blank
Database.

 

I ran the SQL profiler and it virtually does nothing on the SQL End for
those 15 min. and after those 15 min, it starts executing the other Scripts.

 

Any particular reason for this? The log file does not show anything.  The
SQL Profile does not say anything.

 

Below is the code that I used.

 

<Directory Id="INSTALLDIR" Name="$(var.productFolder)">

          <Directory Id="EXTERNAL_DOC_PATH" Name="Patients" />

          <!-- DatabaseTools sub-folder -->

          <Directory Id="DataBaseTools" Name="$(var.productFolderDBTools)">

            <Component Id="SqlComponent" Guid="$(var.componentServiceGuid)"
KeyPath="yes">

              <Condition><![CDATA[INSTALL_TYPE_SERVER="1" AND
DB_ERROR_MESSAGE=""]]></Condition>

              <sql:SqlDatabase Id="SqlDatabase"
Database="$(var.defaultDatabase)" 

User="SQLUser" 

Server="(local)\[SQL_INSTANCE]" 

CreateOnInstall="yes" 

DropOnUninstall="no" 

ContinueOnError="no">

                <sql:SqlScript Id="Panda" BinaryKey="Panda"
ExecuteOnInstall="yes" />

              </sql:SqlDatabase>

            </Component>

          </Directory>

        </Directory>

 

 

 

Any help would be greatly appreciated.

 

TIA

 

Ashutosh