Scenario: You want to deploy a SQL Compact / .NET based application, using private deployment only. Your application depend on a certain .NET Framework version. The table below illustrates your options, as you can see there are special considerations, if your clients only have .NET 4.0 and not .NET 3.5 SP1 installed.
Installing the SQL Server Compact MSI also installs the required Visual C++ runtime files.
Also, notice that all files required for private deployment are included in the private folder in either Program Files or Program Files (x86) (C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Private) for version 4.0.
For information on private deployment, see SQL Server Compact 3.5 SP2 Books Online and this blog post and this reply. Notice that 3.5 SP2 Books Online is only available “offline”.
UPDATE: Also see this blog post: http://erikej.blogspot.com/2011/02/using-sql-server-compact-40-with.html with a sample MSI project for a WPF app.
UPDATE 2: Also see this blog post for some advanced scenarios: SQL Server Compact Private Deployment tweaks
UPDATE 3: Private deployment of 3.5 SP2 article published
SQL Server Compact 3.5 SP2
SQL Server Compact 3.5 SP2 requires .NET 2.0 or later.
| Application Windows platform | SSCE 3.5 SP2 with .NET 2.0 | SSCE 3.5 SP2 with .NET 3.5 SP1 | SSCE 3.5 SP2 with .NET 4.0 |
| XP (no .NET included) | NO | NO | NO |
| XP (.NET 2.0) | YES | NO | NO |
| XP (.NET 3.5 SP1) | YES | YES | NO |
| XP (.NET 4.0 only) | NO | NO | NO (1) |
| XP (.NET 3.5 SP1 and .NET 4.0) | YES | YES | YES |
| Vista (.NET 2.0/3.0 included) | YES | NO | NO |
| Vista (.NET 3.5 SP1) | YES | YES | NO |
| Vista (.NET 3.0 and .NET 4.0) | YES | NO | NO (1) |
| Vista (.NET 3.5 SP1 and .NET 4.0) | YES | YES | YES |
| 7 (.NET 3.5 SP1 included) | YES | YES | NO |
| 7 (.NET 3.5 SP1 and .NET 4.0) | YES | YES | YES |
1: Microsoft Visual C++ 2005 SP1 Redistributable Package (x86) and/or Microsoft Visual C++ 2005 SP1 Redistributable Package (x64) must be installed.
SQL Server Compact 4.0 RTW
SQL Server Compact 4.0 RTW requires .NET 3.5 SP1 or .NET 4.0
| Application Windows platform | SSCE 4.0 with .NET 3.5 SP1 | SSCE 4.0 RTW with .NET 4.0 |
| XP (no .NET included) | NO | NO |
| XP (.NET 3.5 SP1) | YES | NO |
| XP (.NET 4.0 only) | NO | YES |
| XP (.NET 3.5 SP1 and .NET 4.0) | YES | YES |
| Vista (.NET 2.0/3.0 included) | NO | NO |
| Vista (.NET 3.5 SP1) | YES | NO |
| Vista (.NET 3.0 and .NET 4.0) | NO | YES |
| Vista (.NET 3.5 SP1 and .NET 4.0) | YES | YES |
| 7 (.NET 3.5 SP1 included) | YES | NO |
| 7 (.NET 3.5 SP1 and .NET 4.0) | YES | YES |
0 comments:
Post a Comment