Bob,
thanks for the information regarding SQL support in Wix. Could one not use
OleDB or one of the other database access technologies (ODBC) that use a
connection string to get all databases covered in one go? I can take a look at
the source to see how hard it would be to add MySQL support to Wix (presumably
in C++?) with the MySql client library, but I promise nothing.
Is there a good example of a creating a fragment somewhere?
thanks,
Friedrich
----- Original Message ----
From: Bob Arnson <[EMAIL PROTECTED]>
To: Friedrich Brunzema <[EMAIL PROTECTED]>
Cc: WixUsers <wix-users@lists.sourceforge.net>
Sent: Friday, July 20, 2007 12:53:25 PM
Subject: Re: [WiX-users] Initializing a MySQL 5 database
Friedrich Brunzema wrote:
I noticed that there is some SQL support in Wix, but did not
find extensive documentation on this (or an example). At first glance
my guess is that this only works for SQL server installations. Does
someone have more information?
Yes, it's SQL Server-specific. We've talked about adding support for
non-MS databases, especially since both PostgreSQL and MySQL feature
installers built with WiX.<g> But so far, nobody's volunteered.
The setup is actually installing the entire MySQL database
(after reverse-engineering the MySQL setup), which also works great,
but now causes 4-5 min build times for light to compress all the
files. I have actually separated the mysql portions into a merge
module , which basically works and reduces the build to < 1 min, but
now the custom actions break, since the id that [#mysql.exe] references
is in another file - I get a missing foreign key error message from one
of the ICE checkers.
Unless you need to share the merge module, the easiest solution is to
create a Fragment instead of a Module. Use Lit to create a .wixlib that
contains all the files. Otherwise, you need to include all the related
files in the same module.
--
sig://boB
http://joyofsetup.com/
Ask a question on any topic and get answers from real people. Go to
Yahoo! Answers and share what you know at http://ca.answers.yahoo.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
