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

[Ashutosh Vyas]

Anything I could look into to get more info on this ?




-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of
Ashutosh Vyas
Sent: Saturday, September 3, 2016 8:13 PM
To: wix-users at lists.wixtoolset.org
Subject: [wix-users] Wix - Create Database takes long time.

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             


____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant
http://www.firegiant.com/