I don't use the built-in WiX SQL commands I find them too limiting, I prefer to shell out to sqlcmd to run the SQL scripts and use the sqlcmd replaceable parameters. For an example see here: http://neilsleightholm.blogspot.com/2008/08/executing-sqlcmd-from-wix.ht ml.
Neil -----Original Message----- From: dschmitz [mailto:[EMAIL PROTECTED] Sent: 06 October 2008 10:59 To: wix-users@lists.sourceforge.net Subject: [WiX-users] Search & Replace template parameters in SQL Hello, we have lots of SQL scripts here using SQL template parameters looking like this: SQL Management Studio has the possibility to fill these parameters with values using Ctrl+Shift+M Now we are going to automate the execution of these scripts with WiX. The standard Wix SQL cmds SqlScript / SQLString don't seem to do the trick here. I think the only way to solve this is to use a Custom Action which does Search & Replace (maybe with regular expressions) and to pass in the parameter name and parameter value. Does anybody already have an existing solution / a custom action which can solve this problem and wouldn't mind sharing the solution? Thanks in advance Daniel -- View this message in context: http://n2.nabble.com/Search---Replace-template-parameters-in-SQL-tp13004 77p1300477.html Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------ - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
