I think the generally preferred way of handling this is one of:
(1) provide a list of SQL server instances on the machine and allow the 
user to choose which instance to install to
(2) default to [COMPUTERNAME] as the instance name, and allow the user to 
override the choice on the command line of msiexec, or in a dialog if 
running in UI mode.
(3) don't install to SQL, provide scripts for the SQL setup and require 
the administrator to run the SQL scripts for the configuration of the 
database.

I personally like #3 for server-based products (web sites, etc.) since it 
allows the administrator to choose where to install the database objects 
(for instance on another server altogether, etc.) and #2 for desktop-based 
products (except perhaps assume SQLEXPRESS as the default for 
desktop-based products).

Perhaps my preference for #3 is due to my Oracle background and how it's 
much easier to make installs that are NOT touching the DB directly (plus 
Oracle DBAs tend to be much more fussy about topography of their 
databases, instances, etc., at least the ones I've known).  In any case, I 
feel it gives the best of all situations, except that the administrator 
has to do a bit more work in exchange for this flexibility.

Kelly




"Ben Reichelt" <[EMAIL PROTECTED]>

Sent by: [EMAIL PROTECTED]
11/24/2007 02:42 PM

To
"Frank Eden" <[EMAIL PROTECTED]>
cc
wix-users@lists.sourceforge.net
Subject
Re: [WiX-users] Detecting Which version of SQL is installed






I would guess you'd have to write a custom action to investigate what they 
had installed and set it to a variable (like you suggested).

However, just because someone has Sql Server or Sql Express doesn't 
guarantee that it will just be [COMPUTERNAME] or 
[COMPUTERNAME]\SQLEXPRESS. You can install either of those products to any 
name you want. 

On Nov 24, 2007 4:15 PM, Frank Eden <[EMAIL PROTECTED]> wrote:

I am installing a database on the target machine using SqlDatabase
My difficulty is that I do not know whether the end-user
has SQLExpress or SQL installed, so I dont know whether to use

Server='[%COMPUTERNAME]\SQLEXPRESS' 
or
Server='[%COMPUTERNAME]'

Im thinking I should be able to detect which is installed, set a variable,
then use that variable, something like

Server='[%COMPUTERNAME][SQL]'

Any ideas on how to do this? 


--
View this message in context: 
http://www.nabble.com/Detecting-Which-version-of-SQL-is-installed-tf4867935.html#a13929956
 

Sent from the wix-users mailing list archive at Nabble.com.


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft 
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________ 
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users 
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users




**************************************************************************************
This communication is intended solely for the addressee and is
confidential. If you are not the intended recipient, any disclosure, 
copying, distribution or any action taken or omitted to be taken in
reliance on it, is prohibited and may be unlawful.  Unless indicated
to the contrary: it does not constitute professional advice or 
opinions upon which reliance may be made by the addressee or any 
other party, and it should be considered to be a work in progress.
Unless stated otherwise, this communication does not form a prescribed
statement of actuarial opinion under American Academy of Actuaries 
guidelines.
**************************************************************************************
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users

Reply via email to