There seems to be a huge overhead of running sql scripts from within
windows installers so I'm playing with the idea of using skeleton
databases stored in MDf/LDF files, I see there are sqlFileSpec elements
that handle these but i can't get them towork yet, I'm not usinga
script just 2 files and the database details in the parent sqldatabase
element:
<SqlDatabase Id="SQLCreateMeterStreamDatabase2" Database="bob"
Server="[SQLSERVERNAME]" Instance="[SQLINSTANCE]"
CreateOnInstall="yes" DropOnUninstall="yes"
User="MySQLUser" ContinueOnError="no">
<SqlFileSpec Id="bob"
Filename="d:\bob.mdf"></SqlFileSpec>
<SqlLogFileSpec Id="bob1"
Filename="d:\bob_log.ldf"></SqlLogFileSpec>
</SqlDatabase>
Is this how they are expected to be used?
-----Original Message-----
From: Simon Topley
Sent: 13 November 2009 15:07
To: 'wix-users@lists.sourceforge.net'
Subject: RE: SQLScript
hmmmm, it seems that you can run scripts that cahnge other databases
outised of the sqldatabse element the scrit is inside of so maybe it'sa
size issue.
The script I'm trying to run is 16mb... about 300,000 lines of SQL. This
takes about 3 minutes to run if you do it manually.. I've split the file
up it 3mb files and they seem to work although the time required seems
to be huge compared to just running the sql scripts from within SQL
server management studio. is this a known issue?
-----Original Message-----
From: Simon Topley
Sent: 13 November 2009 09:54
To: wix-users@lists.sourceforge.net
Subject: SQLScript
Hello again team, I've got another issue with some SQL scripts I'm
trying to run. I have a large collection of scripts all of them work as
they each refer to a specific database....however I have one big script
that updates tables in multiple databases so I can't put it in one
specific SqlDatabase element.
any ideas? Or will this script need to be split into many parts? (that
could be a bit of a nightmare)
Simon
Disclaimer: This electronic communication and its attachments may contain
confidential, proprietary and/or legally privileged information which are for
the sole use of the intended recipient. If you are not the intended recipient,
any use, distribution, or reproduction of this communication is strictly
prohibited and may be unlawful; please contact the sender and delete this
communication. MWH does not warrant or make any representation regarding this
transmission whatsoever nor does it warrant that it is free from viruses or
defects, correct or reliable. MWH is not liable for any loss or damage that
occurs as a result of this communication entering your computer network.
The views expressed in this message are not necessarily those of MWH. This
communication cannot form a binding agreement unless that is the express intent
of the parties and they are authorized to make such an agreement. MWH reserves
all intellectual property rights contained in this transmission. MWH reserves
the right to monitor any electronic communication sent or received by its
employees. This communication may come from a variety of legal entities within
or associated with the MWH group.
For a full list of details for these entities please see our website at
www.mwhglobal.com. Where business communications relate to the MWH UK Limited
entity, the registered office is Terriers House, 201 Amersham Rd, High Wycombe,
HP13 5AJ Tel: 01494 526240 and the company is registered in England as
registration number 01188070. Where business communications relate to the MWH
Constructors Limited entity, the registered office is as above and the company
is registered in England as registration number 04635724. Where business
communications relate to the MWH Soft Limited entity, the registered office is
as above and the company is registered in England as registration number
6975921.
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
