login      my ps      about      contact  



home instructor-led on-demand! screencasts blogs technical staff


You Can Take it With You » SQL Server 2005 Compact Edition Downloads - Honest, it is for real this time (3rd times a charm)

SQL Server 2005 Compact Edition Downloads - Honest, it is for real this time (3rd times a charm)

You Can Take it With You

Pluralsight Blogs

Syndication

Recent Posts

News

  • Don't miss the next Windows Mobile Webcast... Unit Testing for Mobile Devices: http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032382824&EventCategory=4&culture=en-US&CountryCode=US.

Archives

Ok… It looks like it's finally here. The false-start in December where the SQL Server 2005 Compact Edition folks pulled the downloads has past. Also, me jumping the gun last week and posting the download URLs before the "official" release is over.
 
I checked with the SQL Server 2005 Compact Edition folks on Friday to confirm that it was OK to post the links today (15-January-2007) and they said today is the official release so I should feel free to post the links.
 
So after all that, SQL Server 2005 Compact Edition and all of the related tools are "live and in color". Enjoy it. The added desktop support now gives us a lightweight, in-process (no server process) database for both desktop and Windows Mobile. Just as important, the database format is compatible so moving a database between a desktop computer and a Windows Mobile device is a simple file copy.
 
One thing to note, a few weeks ago it appeared that the install for SQL Server Compact Edition Tools for Visual Studio was going to be linked to from the Visual Studio 2005 SP1 install but that is no longer the case. They're two distinctly separate installs.
 
Here's the URLs for each of the SQL Server Compact Edition downloads
 
SQL Server 2005 Compact Edition Tools for Visual Studio 2005 Service Pack 1
This is for most developers. Basically if you use Visual Studio 2005, this is the install you need. You must first install Visual Studio 2005 SP1.
SQL Server 2005 Compact Edition Developer Software Development Kit
This is only for developers who do not use Visual Studio 2005.
 
SQL Server 2005 Compact Edition Runtime
This is the non-developer install. Use this to install SQL Server 2005 Compact Edition onto end-user computers
 
SQL Server 2005 Compact Edition Server Tools
Use this when setting up a server machine to perform Remote Data Access (RDA) and Merge Replication data synchronization with a SQL Server 2005 Compact Edition database. If you're setting up a developer machine and you've installed SQL Server 2005 Compact Edition Tools for Visual Studio 2005 SP1, you do not need to perform this download. Instead you can use the install file located at %Program Files%\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\Sqlce30setupen.msi.
 
For the non-English version of the downloads, change the displaylang value on the end of the URL from en to appropriate displaylang value for the desired language.
Language
displaylang value
Chinese simplified
zh-cn
Chinese Traditional
zh-tw
English
en
French
fr
German
de
Italian
it
Japanese
ja
Korean
ko
Russian
ru
Spanish
es
Posted Jan 15 2007, 09:36 AM by jim-wilson

Comments

You Can Take it With You wrote SQL Server Compact Edition Released (for real this time)
on 01-15-2007 8:06 AM
cchambers wrote re: SQL Server 2005 Compact Edition Downloads - Honest, it is for real this time (3rd times a charm)
on 01-19-2007 7:03 AM
If I already have SQL Server Mobile and VS2005 w/o SP1 would I benefit by installing SQL Server Compact Edition? Should I install SP1 before doing this. Would the SQL CE install overwrite Mobile or should I uninstall it?
Jim Wilson wrote re: SQL Server 2005 Compact Edition Downloads - Honest, it is for real this time (3rd times a charm)
on 01-19-2007 7:55 AM
I would encourage you to upgrade to SQL Server 2005 Compact Edition (SSCE) because it is the most up-to-date version of the product and includes bug fixes since the release of SQL Mobile. (To my knowledge the list of bug fixes is not yet posted but I'll provide a link when available).

You will need to install VS2005 SP1 before you install SSCE Tools for VS2005 (URLs for both are in the above blog post).

Do NOT uninstall SQL Mobile before installing SSCE Tools for VS2005. The SSCE install will throw an error if SQL Mobile isn't already installed. The SSCE install will remove SQL Mobile but SQL Mobile must be there when the SSCE install starts.

There really isn't any downside to upgrading to SSCE because SSCE and SQL Mobile use the same database format. Therefore, you can create your database using SSCE and it will work just fine if deployed to a device running SQL Mobile.

Hope this helps.
-Jim
CChambers wrote re: SQL Server 2005 Compact Edition Downloads - Honest, it is for real this time (3rd times a charm)
on 01-22-2007 6:09 AM
FYI - Installed VS2005 SP1. Boy that took a long time, but otherwise painless. Installed SSCE for SP1 went real quick. Couldn't tell that it did anything but add a few new folders. It didn't do anything to SQL Server Mobile that I can tell. After redploying, when I open my database in Manager it shows the SQL Server Mobile version as 3.0.5300.0. I thought the new one was 3.1. I'm wondering if I should uninstall Mobile SDK, BOL, etc. and install Compact Edition. Thanks for your help.
dougherty distilled wrote SQL Server Compact Edition For Real and Not Everywhere
on 01-24-2007 6:14 PM
So SQL Server Compact Edition has been release officially.  Remember? It's that product that...

Add a Comment

(required)  
(optional)
(required)  
Remember Me?


home instructor-led training online training blogs

781.749.9238 (East Coast) | 310.251.9901 (West Coast) | Pluralsight, LLC , 185 Lincoln St., Suite 305, Hingham, MA 02043-1741

Copyright © 2008 Pluralsight LLC. All rights reserved.

designed by nukeation