Re: Sql Server CE

Tech-Archive recommends: Speed Up your PC by fixing your registry

For a desktop app, I would seriously consider bootstrapping SQL Express instead of Compact, as it is the full engine. If you have to go to SQL Compact(SQL Mobile, SQL CE, SQL Everywhere - darn this thing changes names), there are boostrappers in the SDK. I am not sure there is one for non CE installs, but if not, look at the bootstrap instructions for other MS software. Always best to download from the source on install, as distributing the bits might break EULAs, etc.

Not sure of transaction locking, as I have not played with a multi app scenario. I would look at the features doc and go from there:
http://download.microsoft.com/download/7/f/c/7fc20778-4e2e-4944-b432-ed74b404e542/sqlservercompactdatasheet_final.doc

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box! |
********************************************
"David Thielen" <thielen@xxxxxxxxxxxxx> wrote in message news:r2fnd45qj0t8411f5t05076knonsb7mv5i@xxxxxxxxxx
Hi;

It looks like Sql Server CE may be exactly what we need. I have 2
questions about it:

1) How do we install it as part of our installer? I can find
download/installers on the Microsoft site but we want to make it an
invisible part of our install. This is for a desktop Windows app - not
a mobile one.

2) If I have 2 windows apps accessing the database and they do
transaction locks when reading/updating a record, does Sql Server CE
support that?

thanks - dave

david@at-at-at@windward.dot.dot.net
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm

.

Quantcast