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
>> <[email protected]>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 <[email protected]>
>>> 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
>>>>> [email protected]
>>>>> 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
>>>> [email protected]
>>>> 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
>>> [email protected]
>>> 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
>> [email protected]
>> 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
> [email protected]
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/wix-users
