If you use the SqlScript element it never installs the files on disk. Unfortunately, it does have a bit of a performance issue so the really big files might run really slowly.
Otherwise, I think you're looking at creating a very complex CustomAction. Tom Crozier wrote: > I have several large (100 MB) sql scripts that I need to run after installing > our product. I would like to create a separate Media cabinet to include them > in (which would NOT get installed onto the user's system) and run the scripts > from there, since I don't want to waste the time and bandwidth to copy them > onto the users machine run them and turn around and delete them. However, I > am not sure what method I should use to call them (Custom Action? Which type) > or how to reference files that are not installed. Currently I have a bat file > that I have used for testing that runs sqlcmd statements. > e.g. sqlcmd -h -1 -d DatabaseName -S ServerName -U UserName -P Password -i > Script1.sql -o Script1.log > Where the DatabaseName, ServerName, UserName and Password would be entered > during the install process. (The database is not created as part of this > installer so the name must be entered by the user). The log file should be > written onto the users system during the install process. > > The only other tricky part is a few of the SQL scripts use data files (that > also I do not want installed on the user's system) that are passed to a > stored procedure, which means the location of these files must be hardcoded > or passed to the script. > > Sql script example: EXEC [InsertRecord] @recordPath = > N'C:\PathToRecords\group1\', @recordName = N'rec0001.rec' > > A code example would be most helpful. > > Thanks - TopCat > > ------------------------------------------------------------------------------ > Crystal Reports - New Free Runtime and 30 Day Trial > Check out the new simplified licensing option that enables unlimited > royalty-free distribution of the report engine for externally facing > server and web deployment. > http://p.sf.net/sfu/businessobjects > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
