Hello, I have just prototyped an installer package using WiX that does all the below you outlined (excepting SQL Server 2005 Express, not 2008) as well as registering COM components manually (i.e not self-registering). It will be a single easy step for your user, however, required a lot of investigative and trial and error to work it out.
BUT... My installer bootstraps .NET framework 3.5 and SQL Server 2005 Express (and a couple other 3rd party items) Installs all required files Registers all COM components (NOT self-reg, btw!!) Creates a new database, tables and users as well as populate the table with data (exectuing scripts, works for stored procs as well) from the newly installed SQL Server 2005 Express installation Uses custom actions (C++ and C#) to work Product Key encryption and store it in the DB Writes registry values (from the register COM components mentioned above) Like I said though, it can all be done, and once you figure it out, quite easily, however, it took me about 120 hours to get it all figured out, create my dialogs and have it work on a separate test machine. I don't know that I have the time to actually write up a tutorial on how I accomplished all of this, I am documenting the process for other devs here at my company, but it's not complete yet. In my humble opinion, WiX is well worth the effort to learn how to figure out all this stuff. We also use Wise installer studio here and THAT sucks!! So in conclusion, everything you mentioned below is possible, it just will take you some effort to figure out. However, it'll take you as much if not more to figure it out using Wise. If you're looking for a step-by-step tutorial on how to bootstrap and setup a a SQL server instance, you'd have to probably wait a bit before I have the time to get to that... Oh and one more final point, the SQL server is installed and a named instance created using credentials I provide (as the DB contains our data, and so is not user accessible), no need for the installing user to do anything related to entering passwords and Sa information. It's defined during the bootstrapping process. -- View this message in context: http://n2.nabble.com/Investigating-use-of-WiX-tp4855273p4866072.html Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
