WiX SQL Install

Question

SQL Programmers:

I need to see how you used WiX to execute a collection of SQL files to the server. The files are to be specified in a separate fragment, auto-generated by heat.

The installer does not need to install these SQL files on the target machine, just execute them. (However it would not be a problem if they were installed.)

I also would like to see the error messages (logs) from these executions if possible. I don't see any logging functionality in the WiX SqlExtension.

For starters, I'm trying to use Neil Sleightholm's idea, because it provides logging. Then extend that to dozens of files from heat.

Thanks!

Rob Mensching · Accepted Answer · 2011-07-25 15:49:33Z

1

I would use the SqlScript element in the WiX toolset instead of sqlcmd.exe. Heat.exe will not be able to generate all this for you, you'll need to author the SqlScript elements by hand.

answered Jul 25, 2011 at 15:49

Rob Mensching

36.3k5 gold badges94 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

WiX SQL Install

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related