There is a performance issue with the SqlScript custom action. It hasn't been fixed yet.
SqlFileSpec cannot be used to attach .mdf files/.ldf files. Instead, install the .mdf/.ldf files then use a SqlString to run the ATTACH SQL command. (I forget the exact syntax but I've used that in a past life). On Fri, Nov 13, 2009 at 8:22 AM, Simon Topley < simon.top...@wallingfordsoftware.com> wrote: > 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 > > -- virtually, Rob Mensching - http://RobMensching.com LLC ------------------------------------------------------------------------------ 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
