Great, I've been looking for version comparision for a long time.
I've updated the conditions (see below). This seems to work, but I
didn't do a lot of testing, yet.
<Fragment>
<util:RegistrySearch Root="HKLM" Key="SOFTWARE\Microsoft\Microsoft
SQL Server Compact Edition\v4.0"
Value="Version" Win64="no"
Result="value" Variable="SqlCe40Version"/>
<PackageGroup Id="SQLServerCompact_4.0">
<ExePackage Id="SQLServerCompact_4.0_x86"
Cache="no" Compressed="no" Vital="no" Permanent="yes"
SourceFile="$(var.TargetDir)SSCERuntime_x86.exe"
DownloadUrl="http://go.microsoft.com/fwlink/?LinkID=253117";
DetectCondition='NOT VersionNT64 AND SqlCe40Version
>= v4.0.8876.1'
InstallCommand="/i /q"
InstallCondition="NOT VersionNT64"/>
<ExePackage Id="SQLServerCompact_4.0_x64"
Cache="no" Compressed="no" Vital="no" Permanent="yes"
SourceFile="$(var.TargetDir)SSCERuntime_x64.exe"
DownloadUrl="http://go.microsoft.com/fwlink/?LinkID=253118";
InstallCommand="/i /q"
InstallCondition="VersionNT64"
DetectCondition='VersionNT64 AND SqlCe40Version >=
v4.0.8876.1'/>
</PackageGroup>
</Fragment>
Am 21.06.2013 16:28, schrieb Rob Mensching:
> To get *version* comparisons the quotes from around the version numbers
> (that makes them strings) and put a "v" in front. So the following should
> evaluate to true: "v4.0.0.0 < v14.0.0.0"
>
>
>
>
> On Fri, Jun 21, 2013 at 12:21 AM, Michael Stoll <unwicht...@mistoll.de>wrote:
>
>> Here're the SQL CE 3.5 and 4.0 packages.
>>
>> There's a significiant difference in the behavior of those two!
>>
>> The SQL CE 4.0 packages detect SQL CE 4.0 of ANY language. While 3.5
>> detects only a specific language.
>> The SQL CE 4.0 package could be altered to look for a specific language,
>> but I like the behavior as it is.
>>
>> Furthermore the SQL CE 4.0 package only detects a specific version. It
>> does not detect any future updates.
>> This is because AFAIK the < and > operators in the conditions do a
>> alphanumerical comparision, which would lead to wrong detections. (like
>> '4.0.0.0' < '14.0.0.0', which is false) And I don't know how to handle
>> that correctly.
>> One option would be to detect ANY 4.0 version. (SqlCe40Version << "4.0."
>> (Starts with operator))
>>
>>
>>
>> <Fragment>
>> <util:RegistrySearch Root="HKLM" Key="SOFTWARE\Microsoft\Microsoft
>> SQL Server Compact Edition\v4.0"
>> Value="Version" Win64="no"
>> Result="value" Variable="SqlCe40Version"/>
>> <PackageGroup Id="SQLServerCompact_4.0">
>> <ExePackage Id="SQLServerCompact_4.0_x86"
>> Cache="no" Compressed="no" Vital="no" Permanent="yes"
>> SourceFile="$(var.TargetDir)SSCERuntime_x86-DEU.msi"
>> DownloadUrl="http://go.microsoft.com/fwlink/?LinkID=253117";
>> DetectCondition='NOT VersionNT64 AND SqlCe40Version =
>> "4.0.8876.1"'
>> InstallCommand="/i /q"
>> InstallCondition="NOT VersionNT64"/>
>> <ExePackage Id="SQLServerCompact_4.0_x64"
>> Cache="no" Compressed="no" Vital="no" Permanent="yes"
>> SourceFile="$(var.TargetDir)SSCERuntime_x64-DEU.msi"
>> DownloadUrl="http://go.microsoft.com/fwlink/?LinkID=253118";
>> InstallCommand="/i /q"
>> InstallCondition="VersionNT64"
>> DetectCondition='VersionNT64 AND SqlCe40Version =
>> "4.0.8876.1"'/>
>> </PackageGroup>
>> </Fragment>
>>
>> <Fragment>
>> <PackageGroup Id="SQLServerCompact_3.5">
>> <MsiPackage Id="SQLServerCompact_3.5_x86"
>> Cache="no" Compressed="no" Vital="no" Visible="yes"
>> SourceFile="$(var.TargetDir)SSCERuntime_x86-DEU.msi"
>> DownloadUrl="http://go.microsoft.com/fwlink/?LinkID=166085&clcid=0x407
>> "
>> Permanent="yes" />
>> <MsiPackage Id="SQLServerCompact_3.5_x64"
>> Cache="no" Compressed="no" Vital="no" Visible="yes"
>> SourceFile="$(var.TargetDir)SSCERuntime_x64-DEU.msi"
>> DownloadUrl="http://go.microsoft.com/fwlink/?LinkID=166086&clcid=0x407
>> "
>> Permanent="yes"
>> InstallCondition="VersionNT64" />
>>
>> </PackageGroup>
>> </Fragment>
>>
>> Am 17.06.2013 16:53, schrieb Michael Stoll:
>>> I've got a SQL CE 3.5 package, that's working well. It uses MSI files,
>>> so detect is easy.
>>>
>>> Note: There's an issue with the x86 on x64 machines:
>>> (http://support.microsoft.com/kb/974247)
>>>
>>> The links are for german culture installers.
>>>
>>> Am 17.06.2013 16:03, schrieb Rob Mensching:
>>>> If you get it working well, it'd be great if you could help us expand
>>>> the
>>>> provided packages and we can get that code in to maybe the SqlExtension.
>>>>
>>>>
>>>> On Mon, Jun 17, 2013 at 6:47 AM, Michael Stoll
>>>> <unwicht...@mistoll.de>wrote:
>>>>
>>>>> I might have been unclear, sorry.
>>>>>
>>>>> I don't want to create the msi package, I just want to bootstrap it.
>>>>> If there's no msi installer, I'd stick to the exe installer.
>>>>> The exe package should look somewhat like this (not testet yet)
>>>>>
>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>>> <Wix xmlns="http://schemas.microsoft.com/wix/2006/wi";
>>>>> xmlns:util="http://schemas.microsoft.com/wix/UtilExtension";>
>>>>> <Fragment>
>>>>> <util:RegistrySearch Root="HKLM"
>>>>> Key="SOFTWARE\Microsoft\Microsoft
>>>>> SQL Server Compact Edition\v4.0\DEU"
>>>>> Value="DesktopRuntimeVersion" Win64="no"
>>>>> Result="value" Variable="DEU_INST"/>
>>>>>
>>>>> <PackageGroup Id="SQLServerCompact_4.0">
>>>>> <ExePackage Id="SQLServerCompact_4.0_x86"
>>>>> Cache="no" Compressed="no" Vital="no"
>>>>> Permanent="yes"
>>>>> SourceFile="$(var.TargetDir)SSCERuntime_x86-DEU.msi"
>>>>> DownloadUrl="
>> http://go.microsoft.com/fwlink/?LinkID=253117&clcid=0x407
>>>>> "
>>>>> DetectCondition='DEU_INST == "4.0.8876.1"'
>>>>> InstallCommand="/i /q" />
>>>>> <ExePackage Id="SQLServerCompact_4.0_x64"Visible="yes"
>>>>> Permanent="yes"
>>>>> SourceFile="$(var.TargetDir)SSCERuntime_x64-DEU.msi"
>>>>> DownloadUrl="
>> http://go.microsoft.com/fwlink/?LinkID=253118&clcid=0x407
>>>>> "
>>>>> InstallCommand="/i /q"
>>>>> InstallCondition="VersionNT64"
>>>>> DetectCondition='DEU_INST == "4.0.8876.1"'/>
>>>>> </PackageGroup>
>>>>> </Fragment>
>>>>> </Wix>
>>>>>
>>>>>
>>>>>
>>>>> Am 16.06.2013 21:19, schrieb Dan Blanchard:
>>>>>> It's pretty easy to distribute SQL ce DLLS, you can just deploy the
>>>>> files. Here is a blog that describes this.
>> http://erikej.blogspot.com/2011/02/using-sql-server-compact-40-with.html
>>>>>>
>>>>>> I made my own merge module
>>>>>>
>>>>>> Hope this helps
>>>>>>
>>>>>> Dan
>>>>>>
>>>>>> Sent from my iPhone
>>>>>>
>>>>>> On Jun 16, 2013, at 6:46 AM, Michael Stoll <unwicht...@mistoll.de>
>>>>> wrote:
>>>>>>> I'm authoring a burn package for SQL CE 4.0.
>>>>>>>
>>>>>>> Are there any preexistend SQL CE packages?
>>>>>>>
>>>>>>> The package should use msi files that are downloaded
>>>>>>> automatically. But
>>>>>>> the only msi files for download, that i could find where the SP1 CTP
>>>>>>> version.
>>>>>>> Is there a msi package out there with a permanent download link or
>>>>>>> do I
>>>>>>> have to stick to the exe package?
>>>>>>>
>>>>>>>
>>>>>>>
>> ------------------------------------------------------------------------------
>>>>>>> This SF.net email is sponsored by Windows:
>>>>>>>
>>>>>>> Build for Windows Store.
>>>>>>>
>>>>>>> http://p.sf.net/sfu/windows-dev2dev
>>>>>>> _______________________________________________
>>>>>>> WiX-users mailing list
>>>>>>> WiX-users@lists.sourceforge.net
>>>>>>> https://lists.sourceforge.net/lists/listinfo/wix-users
>> ------------------------------------------------------------------------------
>>>>>> This SF.net email is sponsored by Windows:
>>>>>>
>>>>>> Build for Windows Store.
>>>>>>
>>>>>> http://p.sf.net/sfu/windows-dev2dev
>>>>>> _______________________________________________
>>>>>> WiX-users mailing list
>>>>>> WiX-users@lists.sourceforge.net
>>>>>> https://lists.sourceforge.net/lists/listinfo/wix-users
>>>>>>
>>>>>
>>>>>
>> ------------------------------------------------------------------------------
>>>>> This SF.net email is sponsored by Windows:
>>>>>
>>>>> Build for Windows Store.
>>>>>
>>>>> http://p.sf.net/sfu/windows-dev2dev
>>>>> _______________________________________________
>>>>> WiX-users mailing list
>>>>> WiX-users@lists.sourceforge.net
>>>>> https://lists.sourceforge.net/lists/listinfo/wix-users
>>>>>
>>>>>
>> ------------------------------------------------------------------------------
>>>> This SF.net email is sponsored by Windows:
>>>>
>>>> Build for Windows Store.
>>>>
>>>> http://p.sf.net/sfu/windows-dev2dev
>>>> _______________________________________________
>>>> WiX-users mailing list
>>>> WiX-users@lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/wix-users
>>>>
>>>
>>>
>>>
>> ------------------------------------------------------------------------------
>>> This SF.net email is sponsored by Windows:
>>>
>>> Build for Windows Store.
>>>
>>> http://p.sf.net/sfu/windows-dev2dev
>>>
>>>
>>> _______________________________________________
>>> WiX-users mailing list
>>> WiX-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/wix-users
>>
>> ------------------------------------------------------------------------------
>> This SF.net email is sponsored by Windows:
>>
>> Build for Windows Store.
>>
>> http://p.sf.net/sfu/windows-dev2dev
>> _______________________________________________
>> WiX-users mailing list
>> WiX-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/wix-users
>>
>>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Windows:
>
> Build for Windows Store.
>
> http://p.sf.net/sfu/windows-dev2dev
> _______________________________________________
> WiX-users mailing list
> WiX-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/wix-users
>
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
