Embedded XP & SQL CE

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

We have a client server product using SQL Express/Microsoft SQL Server
as a backend. we have a lot of StoredProcedures we use in the product.

We are now planning to create a low end version of the server product
which can run off a device running Windows XP Embedded. So i have
thinking of using SQL CE because of its low footprint instead of SQL
Express. Any reasons why i should not. The other otpion i have is to
build my own data store...

Thanks for the help.
.

Relevant Pages

  • Re: Embedded XP & SQL CE
    ... SQL CE should be fine and a huge improvement over writing your own data store. ... You won't be able to use your stored procedures although you can store the statement text as resource strings for easier maintenance. ... The other major thing to be aware of since you mentioned "server product" is that although SQL CE does support multiple concurrent connections from different processes, all those processes must be on the same machine. ...
    (microsoft.public.sqlserver.ce)
  • Re: NE1 know of a good SQL Forum/NG??
    ... I was actually looking for more of a place that was good for just SQL ... problems more than help on the Server product itself, ... >> I'm sorely lacking in some SQL skills and need a recommendation to a ... >> place to bounce some problems around for some answers. ...
    (microsoft.public.vb.general.discussion)
  • Re: SQL CE
    ... You can use SQL CE 2.0 with MSDE. ... > Is SQL CE only compatable wil the full SQL 2000 Server product or can you ...
    (microsoft.public.sqlserver.ce)
  • RE: SQL Server CE - stored Procedures
    ... Also note that there are some other limitations on SQL CE 2.0 beyond stored ... auto-reclamation of database space. ... > Can anybody tell me here, how i can use StoredProcedures in a SQL Server CE ...
    (microsoft.public.pocketpc.developer)