Hi, I had the same problem, my batch is made of a few scripts 60k lines long each, and I moved to invoking sqlcmd.exe from a CA directly, instead of Wix's SqlScript.
See Neil's blog for full details: http://neilsleightholm.blogspot.com/2008/08/executing-sqlcmd-from-wix.html This reduced execution time from 1 hour to 10 mins. Eitan -----Original Message----- From: David Reed [mailto:david.r...@microsoft.com] Sent: Saturday, January 24, 2009 7:44 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQL Database with WiX v3 It really depends on what those 9k scripts are doing. If your scripts are a raft of INSERT statements or other transactions, then you can probably switch to CSVs and bulk load (much faster), which is what we do with AdventureWorks now for SQL Server 2008 samples. The WiX3 code for ours is checked into CodePlex here along with the MSBuild scripts, etc: http://www.codeplex.com/SqlServerSamples/SourceControl/ListDownloadableCommi ts.aspx In our experience with AdventureWorks' installers, switching to a backup/restore is likely to bloat the size of your installer quite a bit because the BAK files aren't nearly as compressible (if at all) as script files are... ________________________________________ From: Eric Latendresse [elatendre...@optimum-solutions.com] Sent: Friday, January 23, 2009 13:10 To: General discussion for Windows Installer XML toolset. Subject: [WiX-users] Creating SQL Database with WiX v3 I am creating a SQL database with my installer. Right now I have approximately 9000 scripts to be run after the database is created. This is taking around 20mins for the install to complete. Is there anything I can do to speed this process up? I thought about running a single script to restore the database from a backup file of the database, but thought I'd ask if there was a better way. Eric Latendresse ---------------------------------------------------------------------------- -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ---------------------------------------------------------------------------- -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
