CODEWITHSUNDEEP
sqlwix
Shaun Merrill
Shaun Merrill

Reputation: 21

WiX SQL Install

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!

Upvotes: 2

Views: 663

Answers (1)

Rob Mensching
Rob Mensching

Reputation: 35831

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.

Upvotes: 1

Related Questions