Re: [WiX-users] Creating SQL Database with WiX v3
Still getting the error and no way to debug? Are there any other options? This way of restoring a database SHOULD work, right? Eric -Original Message- From: Eric Latendresse [mailto:elatendre...@optimum-solutions.com] Sent: Tuesday, January 27, 2009 8:32 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQL Database with WiX v3 Yes, The sql server is local. It creates the blank database correctly and I can see the .mdf and .ldf files at the time of the error. The backup file is there as well. The problem must be with the restore script. I can run the script manually and it works fine. Is there anything that would cause WiX to read the sqlstring wrong? Maybe the single quotes aren't coming through as they should? Is there a WiX log or a way to add one so that I can get a more detailed message? Eric -Original Message- From: David Reed [mailto:david.r...@microsoft.com] Sent: Monday, January 26, 2009 3:34 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQL Database with WiX v3 That's often a 404-equivalent. There's usually more info in the server error log. Error -2147217900 Cannot open backup device 'incorrect_path_2_file.bak'. Device error or device off-line. See the SQL Server error log for more details. Make sure the SQL Server process has permissions to that path and that the file actually exists there. You are trying to restore to a local server instance, right? Not a remote server? -Original Message- From: Eric Latendresse [mailto:elatendre...@optimum-solutions.com] Sent: Monday, January 26, 2009 13:21 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQL Database with WiX v3 I tried to restore the database from a backup file during the initial install and am getting this error below. Is there WiX log or something where I can get some more info on how to debug this? Below is my code and I think this should work. Anyone have any ideas? Thanks in advance for you help. Component Id=SuiteDatabaseComponent Guid=d6e96011-3252-4e85-80b5-b1ff64045e88 File Id=DatabaseBackup Name=SuiteBlank.bak Source=..\..\Database\Backups\SuiteBlank.bak / CreateFolder/ !-- installs database -- sql:SqlDatabase Id=db1 Server=[SQLSERVER] Instance=[SQLINSTANCE] Database=Suite CreateOnInstall=yes ConfirmOverwrite=yes DropOnUninstall=no User=SQLUser !-- define where the database files are saved -- sql:SqlFileSpec Id=mdf Name=Suite_Data Filename=[DATABASEDIR]Suite_Data.mdf Size=2MB GrowthSize=2MB/ sql:SqlLogFileSpec Id=ldf Name=Suite_Log Filename=[DATABASEDIR]Suite_Log.ldf/ /sql:SqlDatabase sql:SqlString Id='RestoreDB' SqlDb='db1' ContinueOnError='no' ExecuteOnInstall='yes' SQL=RESTORE DATABASE Suite FROM DISK = '[DATABASEDIR]SuiteBlank.bak' WITH MOVE 'Suite_Data' TO '[DATABASEDIR]Suite_Data.mdf', MOVE 'Suite_Log' TO '[DATABASEDIR]Suite_Log.ldf',REPLACE/ /Component Error -2147217900: failed to execute SQL string, error detail: RESTORE DATABASE is terminating abnormally., SQL key: RestoreDB SQL string: RESTORE DATABASE Suite FROM DISK = 'G:\Database\SuiteBlank.bak' WITH MOVE 'Suite_Data' TO G:\ ...\Suite_Log.ldf',REPLACE Eric Latendresse -Original Message- From: David Reed [mailto:david.r...@microsoft.com] Sent: Friday, January 23, 2009 11:44 PM 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/ListDownloadableC ommits.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
Re: [WiX-users] Creating SQL Database with WiX v3
Is it possible the Sql Database is locked after it creates it? The .mdf and .ldf file DO get created before the .msi is finished, but maybe because the .msi isn't complete the files are locked? Just a thought. If this is the case is there a way around this? TO create the blanks sql Database, unlock it, then run the restore script? Eric Latendresse -Original Message- From: Eric Latendresse [mailto:elatendre...@optimum-solutions.com] Sent: Wednesday, January 28, 2009 8:59 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQL Database with WiX v3 Still getting the error and no way to debug? Are there any other options? This way of restoring a database SHOULD work, right? Eric -Original Message- From: Eric Latendresse [mailto:elatendre...@optimum-solutions.com] Sent: Tuesday, January 27, 2009 8:32 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQL Database with WiX v3 Yes, The sql server is local. It creates the blank database correctly and I can see the .mdf and .ldf files at the time of the error. The backup file is there as well. The problem must be with the restore script. I can run the script manually and it works fine. Is there anything that would cause WiX to read the sqlstring wrong? Maybe the single quotes aren't coming through as they should? Is there a WiX log or a way to add one so that I can get a more detailed message? Eric -Original Message- From: David Reed [mailto:david.r...@microsoft.com] Sent: Monday, January 26, 2009 3:34 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQL Database with WiX v3 That's often a 404-equivalent. There's usually more info in the server error log. Error -2147217900 Cannot open backup device 'incorrect_path_2_file.bak'. Device error or device off-line. See the SQL Server error log for more details. Make sure the SQL Server process has permissions to that path and that the file actually exists there. You are trying to restore to a local server instance, right? Not a remote server? -Original Message- From: Eric Latendresse [mailto:elatendre...@optimum-solutions.com] Sent: Monday, January 26, 2009 13:21 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQL Database with WiX v3 I tried to restore the database from a backup file during the initial install and am getting this error below. Is there WiX log or something where I can get some more info on how to debug this? Below is my code and I think this should work. Anyone have any ideas? Thanks in advance for you help. Component Id=SuiteDatabaseComponent Guid=d6e96011-3252-4e85-80b5-b1ff64045e88 File Id=DatabaseBackup Name=SuiteBlank.bak Source=..\..\Database\Backups\SuiteBlank.bak / CreateFolder/ !-- installs database -- sql:SqlDatabase Id=db1 Server=[SQLSERVER] Instance=[SQLINSTANCE] Database=Suite CreateOnInstall=yes ConfirmOverwrite=yes DropOnUninstall=no User=SQLUser !-- define where the database files are saved -- sql:SqlFileSpec Id=mdf Name=Suite_Data Filename=[DATABASEDIR]Suite_Data.mdf Size=2MB GrowthSize=2MB/ sql:SqlLogFileSpec Id=ldf Name=Suite_Log Filename=[DATABASEDIR]Suite_Log.ldf/ /sql:SqlDatabase sql:SqlString Id='RestoreDB' SqlDb='db1' ContinueOnError='no' ExecuteOnInstall='yes' SQL=RESTORE DATABASE Suite FROM DISK = '[DATABASEDIR]SuiteBlank.bak' WITH MOVE 'Suite_Data' TO '[DATABASEDIR]Suite_Data.mdf', MOVE 'Suite_Log' TO '[DATABASEDIR]Suite_Log.ldf',REPLACE/ /Component Error -2147217900: failed to execute SQL string, error detail: RESTORE DATABASE is terminating abnormally., SQL key: RestoreDB SQL string: RESTORE DATABASE Suite FROM DISK = 'G:\Database\SuiteBlank.bak' WITH MOVE 'Suite_Data' TO G:\ ...\Suite_Log.ldf',REPLACE Eric Latendresse -Original Message- From: David Reed [mailto:david.r...@microsoft.com] Sent: Friday, January 23, 2009 11:44 PM 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
Re: [WiX-users] Creating SQL Database with WiX v3
Run sql profiler when you install to see what is happening. Its how I debug my database install issues. Dave W -Original Message- From: Eric Latendresse [mailto:elatendre...@optimum-solutions.com] Sent: 28 January 2009 15:11 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQL Database with WiX v3 Is it possible the Sql Database is locked after it creates it? The .mdf and .ldf file DO get created before the .msi is finished, but maybe because the .msi isn't complete the files are locked? Just a thought. If this is the case is there a way around this? TO create the blanks sql Database, unlock it, then run the restore script? Eric Latendresse -Original Message- From: Eric Latendresse [mailto:elatendre...@optimum-solutions.com] Sent: Wednesday, January 28, 2009 8:59 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQL Database with WiX v3 Still getting the error and no way to debug? Are there any other options? This way of restoring a database SHOULD work, right? Eric -Original Message- From: Eric Latendresse [mailto:elatendre...@optimum-solutions.com] Sent: Tuesday, January 27, 2009 8:32 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQL Database with WiX v3 Yes, The sql server is local. It creates the blank database correctly and I can see the .mdf and .ldf files at the time of the error. The backup file is there as well. The problem must be with the restore script. I can run the script manually and it works fine. Is there anything that would cause WiX to read the sqlstring wrong? Maybe the single quotes aren't coming through as they should? Is there a WiX log or a way to add one so that I can get a more detailed message? Eric -Original Message- From: David Reed [mailto:david.r...@microsoft.com] Sent: Monday, January 26, 2009 3:34 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQL Database with WiX v3 That's often a 404-equivalent. There's usually more info in the server error log. Error -2147217900 Cannot open backup device 'incorrect_path_2_file.bak'. Device error or device off-line. See the SQL Server error log for more details. Make sure the SQL Server process has permissions to that path and that the file actually exists there. You are trying to restore to a local server instance, right? Not a remote server? -Original Message- From: Eric Latendresse [mailto:elatendre...@optimum-solutions.com] Sent: Monday, January 26, 2009 13:21 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQL Database with WiX v3 I tried to restore the database from a backup file during the initial install and am getting this error below. Is there WiX log or something where I can get some more info on how to debug this? Below is my code and I think this should work. Anyone have any ideas? Thanks in advance for you help. Component Id=SuiteDatabaseComponent Guid=d6e96011-3252-4e85-80b5-b1ff64045e88 File Id=DatabaseBackup Name=SuiteBlank.bak Source=..\..\Database\Backups\SuiteBlank.bak / CreateFolder/ !-- installs database -- sql:SqlDatabase Id=db1 Server=[SQLSERVER] Instance=[SQLINSTANCE] Database=Suite CreateOnInstall=yes ConfirmOverwrite=yes DropOnUninstall=no User=SQLUser !-- define where the database files are saved -- sql:SqlFileSpec Id=mdf Name=Suite_Data Filename=[DATABASEDIR]Suite_Data.mdf Size=2MB GrowthSize=2MB/ sql:SqlLogFileSpec Id=ldf Name=Suite_Log Filename=[DATABASEDIR]Suite_Log.ldf/ /sql:SqlDatabase sql:SqlString Id='RestoreDB' SqlDb='db1' ContinueOnError='no' ExecuteOnInstall='yes' SQL=RESTORE DATABASE Suite FROM DISK = '[DATABASEDIR]SuiteBlank.bak' WITH MOVE 'Suite_Data' TO '[DATABASEDIR]Suite_Data.mdf', MOVE 'Suite_Log' TO '[DATABASEDIR]Suite_Log.ldf',REPLACE/ /Component Error -2147217900: failed to execute SQL string, error detail: RESTORE DATABASE is terminating abnormally., SQL key: RestoreDB SQL string: RESTORE DATABASE Suite FROM DISK = 'G:\Database\SuiteBlank.bak' WITH MOVE 'Suite_Data' TO G:\ ...\Suite_Log.ldf',REPLACE Eric Latendresse -Original Message- From: David Reed [mailto:david.r...@microsoft.com] Sent: Friday, January 23, 2009 11:44 PM To: General discussion for Windows Installer XML
Re: [WiX-users] Creating SQL Database with WiX v3
I tried to restore the database from a backup file during the initial install and am getting this error below. Is there WiX log or something where I can get some more info on how to debug this? Below is my code and I think this should work. Anyone have any ideas? Thanks in advance for you help. Component Id=SuiteDatabaseComponent Guid=d6e96011-3252-4e85-80b5-b1ff64045e88 File Id=DatabaseBackup Name=SuiteBlank.bak Source=..\..\Database\Backups\SuiteBlank.bak / CreateFolder/ !-- installs database -- sql:SqlDatabase Id=db1 Server=[SQLSERVER] Instance=[SQLINSTANCE] Database=Suite CreateOnInstall=yes ConfirmOverwrite=yes DropOnUninstall=no User=SQLUser !-- define where the database files are saved -- sql:SqlFileSpec Id=mdf Name=Suite_Data Filename=[DATABASEDIR]Suite_Data.mdf Size=2MB GrowthSize=2MB/ sql:SqlLogFileSpec Id=ldf Name=Suite_Log Filename=[DATABASEDIR]Suite_Log.ldf/ /sql:SqlDatabase sql:SqlString Id='RestoreDB' SqlDb='db1' ContinueOnError='no' ExecuteOnInstall='yes' SQL=RESTORE DATABASE Suite FROM DISK = '[DATABASEDIR]SuiteBlank.bak' WITH MOVE 'Suite_Data' TO '[DATABASEDIR]Suite_Data.mdf', MOVE 'Suite_Log' TO '[DATABASEDIR]Suite_Log.ldf',REPLACE/ /Component Error -2147217900: failed to execute SQL string, error detail: RESTORE DATABASE is terminating abnormally., SQL key: RestoreDB SQL string: RESTORE DATABASE Suite FROM DISK = 'G:\Database\SuiteBlank.bak' WITH MOVE 'Suite_Data' TO G:\ ...\Suite_Log.ldf',REPLACE Eric Latendresse -Original Message- From: David Reed [mailto:david.r...@microsoft.com] Sent: Friday, January 23, 2009 11:44 PM 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/ListDownloadableC ommits.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
Re: [WiX-users] Creating SQL Database with WiX v3
That's often a 404-equivalent. There's usually more info in the server error log. Error -2147217900 Cannot open backup device 'incorrect_path_2_file.bak'. Device error or device off-line. See the SQL Server error log for more details. Make sure the SQL Server process has permissions to that path and that the file actually exists there. You are trying to restore to a local server instance, right? Not a remote server? -Original Message- From: Eric Latendresse [mailto:elatendre...@optimum-solutions.com] Sent: Monday, January 26, 2009 13:21 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQL Database with WiX v3 I tried to restore the database from a backup file during the initial install and am getting this error below. Is there WiX log or something where I can get some more info on how to debug this? Below is my code and I think this should work. Anyone have any ideas? Thanks in advance for you help. Component Id=SuiteDatabaseComponent Guid=d6e96011-3252-4e85-80b5-b1ff64045e88 File Id=DatabaseBackup Name=SuiteBlank.bak Source=..\..\Database\Backups\SuiteBlank.bak / CreateFolder/ !-- installs database -- sql:SqlDatabase Id=db1 Server=[SQLSERVER] Instance=[SQLINSTANCE] Database=Suite CreateOnInstall=yes ConfirmOverwrite=yes DropOnUninstall=no User=SQLUser !-- define where the database files are saved -- sql:SqlFileSpec Id=mdf Name=Suite_Data Filename=[DATABASEDIR]Suite_Data.mdf Size=2MB GrowthSize=2MB/ sql:SqlLogFileSpec Id=ldf Name=Suite_Log Filename=[DATABASEDIR]Suite_Log.ldf/ /sql:SqlDatabase sql:SqlString Id='RestoreDB' SqlDb='db1' ContinueOnError='no' ExecuteOnInstall='yes' SQL=RESTORE DATABASE Suite FROM DISK = '[DATABASEDIR]SuiteBlank.bak' WITH MOVE 'Suite_Data' TO '[DATABASEDIR]Suite_Data.mdf', MOVE 'Suite_Log' TO '[DATABASEDIR]Suite_Log.ldf',REPLACE/ /Component Error -2147217900: failed to execute SQL string, error detail: RESTORE DATABASE is terminating abnormally., SQL key: RestoreDB SQL string: RESTORE DATABASE Suite FROM DISK = 'G:\Database\SuiteBlank.bak' WITH MOVE 'Suite_Data' TO G:\ ...\Suite_Log.ldf',REPLACE Eric Latendresse -Original Message- From: David Reed [mailto:david.r...@microsoft.com] Sent: Friday, January 23, 2009 11:44 PM 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/ListDownloadableC ommits.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
Re: [WiX-users] Creating SQL Database with WiX v3
-2147217900 == DB_E_ERRORSINCOMMAND oledberr.h Unfortunately, more detail is not provided. -Original Message- From: Eric Latendresse [mailto:elatendre...@optimum-solutions.com] Sent: Monday, January 26, 2009 13:21 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQL Database with WiX v3 I tried to restore the database from a backup file during the initial install and am getting this error below. Is there WiX log or something where I can get some more info on how to debug this? Below is my code and I think this should work. Anyone have any ideas? Thanks in advance for you help. Component Id=SuiteDatabaseComponent Guid=d6e96011-3252-4e85-80b5-b1ff64045e88 File Id=DatabaseBackup Name=SuiteBlank.bak Source=..\..\Database\Backups\SuiteBlank.bak / CreateFolder/ !-- installs database -- sql:SqlDatabase Id=db1 Server=[SQLSERVER] Instance=[SQLINSTANCE] Database=Suite CreateOnInstall=yes ConfirmOverwrite=yes DropOnUninstall=no User=SQLUser !-- define where the database files are saved -- sql:SqlFileSpec Id=mdf Name=Suite_Data Filename=[DATABASEDIR]Suite_Data.mdf Size=2MB GrowthSize=2MB/ sql:SqlLogFileSpec Id=ldf Name=Suite_Log Filename=[DATABASEDIR]Suite_Log.ldf/ /sql:SqlDatabase sql:SqlString Id='RestoreDB' SqlDb='db1' ContinueOnError='no' ExecuteOnInstall='yes' SQL=RESTORE DATABASE Suite FROM DISK = '[DATABASEDIR]SuiteBlank.bak' WITH MOVE 'Suite_Data' TO '[DATABASEDIR]Suite_Data.mdf', MOVE 'Suite_Log' TO '[DATABASEDIR]Suite_Log.ldf',REPLACE/ /Component Error -2147217900: failed to execute SQL string, error detail: RESTORE DATABASE is terminating abnormally., SQL key: RestoreDB SQL string: RESTORE DATABASE Suite FROM DISK = 'G:\Database\SuiteBlank.bak' WITH MOVE 'Suite_Data' TO G:\ ...\Suite_Log.ldf',REPLACE Eric Latendresse -Original Message- From: David Reed [mailto:david.r...@microsoft.com] Sent: Friday, January 23, 2009 11:44 PM 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/ListDownloadableC ommits.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
Re: [WiX-users] Creating SQL Database with WiX v3
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
Re: [WiX-users] Creating SQL Database with WiX v3
The CustomAction code processing SQL Scripts could be improved quite a bit. It's incrementally grown over time and I think needs a rewrite to take into account all of the cases (which weren't known when it was originally written) and do it quickly. Unfortunately, it's too late in the WiX v3 time line to do that but is totally something to consider in WiX v4. If you have gigantic scripts, the one of the suggestions below are probably wise (although I hate to have you have to shell out to an external executable since that is so much more fragile and less communicative than a well written CustomAction). -Original Message- From: Eitan Behar [mailto:ei...@baconao.net] Sent: Saturday, January 24, 2009 00:13 To: 'General discussion for Windows Installer XML toolset.' Subject: Re: [WiX-users] Creating SQL Database with WiX v3 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 -- 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
[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
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/ListDownloadableCommits.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