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
