Wix: Is there any wix command to create database user?

2.3k views Asked by At

Is they any wix command I can use to create database and to also add a user to the database? If yes, is there any example on how to do this?

2

There are 2 answers

0
Dessus On BEST ANSWER

I would recommend you try the following:

  1. Create your sql database using techniques mentioned here: Wix: create a sql server database at a specified location

  2. Create a user via SQL: http://msdn.microsoft.com/en-us/library/ms173463.aspx

  3. Run your sql via wix using: http://nicholas.piasecki.name/blog/2009/09/running-update-sql-scripts-during-minor-upgrades-with-wix/
0
Daniel Morritt On

Check out the SQL extension here.

You'll need to add a reference to it in your installer project, an example of this can be found here.