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